Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Aug 10 '10 at 12:11

This question came from our site for professional and enthusiast programmers.

    
Are you on SQL Server 2005 and above? Do you have a baseline for your Normal? –  DaniSQL Aug 10 '10 at 17:26

4 Answers 4

up vote 2 down vote accepted

Use a methodical approach like Waits and Queues. Its a proven successful performance troubleshooting methodology that will guide you down the right path.

share|improve this answer

I think you have to provide some more information if you want any decent answers. Example:

  • What kind of server is it. (what do you server: web, ftp etc)
  • What Applications does it run
  • How is the user situation.

Best Regards.

share|improve this answer

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.