SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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)

Top 10 Wait State Issues Reporter

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.

Total article views: 1682 | Views in the last 30 days: 1