Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Rudy Panigas,
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.