It is a great article and as Mario pointed out it is in right direction. I hope to see session level waitstats capture feature in SQL 2005, together with object level IO Statistics.

In this article however, I have a question about waitstat capture procedure. It captures by default data 10 times every 10 minutes, however the report produced only prints detail about the last sample. The waits can't be summed from the first sampling to the last, it needs dbcc sqlperf (waitstats,clear) within the sampling loop to be more useful.

SHAILESH1/31/2005 2:27:40 PM

Wonderful! Finally after all these years Microsoft engineer(s) see the light. Wait event based tuning is there for almost ten years in the Oracle world. Tom gives a very good explanation about the how's and why's, and the first proper 'wait event' documentation ever!
I hope this will eventually lead to a per session wait interface, and even more detailed documentation.

Mario Broodbakker, The Netherlands 5/10/2004 6:13:52 AM

Very relevant and proffessional

tom parnell 4/28/2004 1:31:10 AM

Could you give me the syntax for run the track_waitlist stored procedure?

thanks, jodi

Jodi Pritchard 4/26/2004 3:13:03 PM

The article gives relative ratios of various counters (A > B is good) but how does 2/1 compare to 10/1? More precision please.

Mark Pollina 4/22/2004 3:43:31 PM

Excellent article. It has helped me determine which items are not responsible for application performance issues we are experiencing.

Matthew Robinette 3/3/2004 12:17:01 PM

Excellent article. It has helped me determine which items are not responsible for application performance issues we are experiencing.

In virtually every issue of SqlMag there is at least one article that pertains to an issue I am currently experiencing.

Thanks for the help!

Matthew Robinette 3/3/2004 12:17:01 PM

Thank you Tom for a very interesting article.
I am using your methodology whenever we have a perfromance problem.
I hope in future articles you' ll show us more of the tools/scripts in the "SQL Server Customer Advisory Team" tool box.

Cheers

Rachid

rachid.ould-hamouda 2/10/2004 3:38:31 PM

Great artiI was reading the latest article Opening Microsoft's Performance-Tuning Toolbox and was trying to locate the document "Wait Types, Perfmon Counters and Correlations" which is specified in the article. I cannot locate this document. Can you please tell me how I can get it?

Thank you.

Pete Williams 1/3/2004 2:37:29 PM