Thank this author by sharing:
By Rudy Panigas, 2012/11/22
The execution of this script will produce a report of the top 10 issues with wait states. You can modiy this script to produce more or less information as needed. Full descriptions are provided for each wait state.
Hope you find it helpful.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com