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
(3)
Add to favorites
Databases
8/10/2009
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Link not working
    1 Posts | Last post February 02, 2012
    • Even this link is not working
      http://gallery.​technet.microso​ft.com/ScriptCe​nter/en-us/8c90​bd2e-9def-4f44-​bce4-e5dae4d86f​71 
  • 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 http://gallery.technet.microsoft.com/ScriptCenter/en-us/8c90bd2e-9def-4f44-bce4-e5dae4d86f71 as the associated link the word document "Performance_Tuning_Waits_Queues.doc" points to a different script 
    • Good troubleshooting, Adam! Thanks!