THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Andrew Kelly

What are you waiting for?

Another question I asked at my pre-con seminar last week at PASS in Seattle troubled me somewhat. This question was “How many people currently collect Wait Stats.” Just a few people raised their hands out of about 105 in total. While you do have to keep in mind that this session was for people wanting to know more about performance monitoring it was still a very low percentage. Collecting Wait Stats is such a simple task and has virtually no overhead. Reporting on it is easy as well. So easy in fact that together with the wealth of information Wait Stats can give you there is no excuse for not collecting these figures on a regular basis. So if you are not I have to say shame on youJ.  I won’t go into details about how to collect or analyze these since the SQL Server Customer Advisory Team has a new web site full of information on subjects just like this and a lot more. If you haven’t checked out this site yet you should make it a priority.  This is going to be one of the most popular SQL Server sites in a very short time when it comes to performance and scalability tips and documentation.  Wait Stats were just a teaser to get you interested so don’t stop there, enjoy all the great documentation.

 

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

 

Published Friday, November 24, 2006 2:29 PM by Andrew Kelly

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

DarrenN said:

There are hundreds of different wait stats here. Whew...this isn't as easy as I hoped it would be... is there any quick guide to which one is more important than the others.  I expect it would also depend on my environment...another complication. No wonder people don't bother.

March 30, 2007 2:56 PM
 

Andrew Kelly said:

The ones to pay attention to are usually the ones that have the most waits. There are a few exceptions but this should get you started:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx

March 30, 2007 3:08 PM
 

Corrector said:

Same on you too ;)

The link you posted doesnt work!

December 22, 2013 2:37 AM
 

Andrew Kelly said:

It's not surprising that a link from MS has changed in the 7 years that it was posted as MS seems to like to do that :).  Here is the current link for the SQL Server Customer Advisory Team (CAT).  http://blogs.msdn.com/b/sqlcat/

December 22, 2013 9:36 AM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement