List Top Wait Types for a Workload

Sample stored procedure that lists the top wait types for a workload. See comments for additional information. This stored procedure, contributed by Microsoft's Tom Davidson, requ

4.3 Star
Add to favorites
E-mail Twitter Digg Facebook
  • Link not working
    1 Posts | Last post February 02, 2012
    • Even this link is not working
  • waitstats table
    3 Posts | Last post November 15, 2011
    • When i run this proc it errors saying I don't have the waitstats table, however the script does not include the DDL for this table
    • I've found the corresponsing script that this one depends on. Would be good to add a link to this as the associated link the word document "Performance_Tuning_Waits_Queues.doc" points to a different script 
    • Good troubleshooting, Adam! Thanks!