Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog

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
Report abuse to Microsoft
Sign in to ask a question

  • Answer the question | Hide
    Link not working
    1 Posts | Last post February 02, 2012
    • Written 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
  • Answer the question | Hide
    waitstats table
    3 Posts | Last post November 15, 2011
    • Written January 20, 2010 
      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
    • Written January 20, 2010 
      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
    • Written November 15, 2011 
      Good troubleshooting, Adam! Thanks!