My server has been running slightly slower than normal.
I was wondering what strategies I could do to evaluate the speed of my server, and enhance it
This question covers database interaction, I/O, and anything else someone might need to know
My server has been running slightly slower than normal.
I was wondering what strategies I could do to evaluate the speed of my server, and enhance it
This question covers database interaction, I/O, and anything else someone might need to know
Use a methodical approach like Waits and Queues. Its a proven successful performance troubleshooting methodology that will guide you down the right path.
I think you have to provide some more information if you want any decent answers. Example:
Best Regards.
As @nenne mentioned its hard to tell how to improve the performance of your servers with such little information. But if you are on SQL SErver 2005 and above I suggest you use the right DMV's and start checking for the top 5 or 10 most expensive queries and also check the wait stats: Is sql server waiting on IO, CPU or memory? Is there any blocking issues? Is your statistics updated? You can use profiler and Perfmon to investigate the root cause of your problem.
As has been said before this is very open ended but if you have noticed a decline in performance and have no maintenance routine you may want to look at rebuilding indexes (all or just those that require it dependant on maintenance Window available and effort). Also Updating statistics as Dani mentioned.
Anything interesting in event viewer, any hardware that might not report errors in there so will require you to use vendor supplied tools.
If you've still got issues look into perfmon counters and dmv's as well as profiler.
You could start worse places than http://sqlserverpedia.com/wiki/Performance_Tuning
Cheers