Retrieve Waiter List Information

Sample script that retrieves wait list information. The Waiter list contains resource waits waiting for the resource. Once a resource is available the corresponding session_id is

 
 
 
 
 
4 Star
(2)
Add to favorites
Databases
8/10/2009
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Track_waitstats_2005
    2 Posts | Last post August 31, 2013
    • The article, http://msdn.microsoft.com/en-us/library/cc966413.aspx, has a link to this script center for stored procedure, Track_waitstats_2005. I do not find stored proc, Track_waitstats_2005, here. Any guidance is appreciated. 
      
      -Jeelani
    • I found it locates at here http://gallery.technet.microsoft.com/scriptcenter/8c90bd2e-9def-4f44-bce4-e5dae4d86f71
  • Not VB ??
    2 Posts | Last post November 15, 2011
    • Hi Folks,
      
      Just the most minor point in that the script is shown as a "VB" script. Clearly it's a T-SQL script.
      
      Regards,
      
      Greg
    • Good catch!
  • Testing for user sessions
    2 Posts | Last post November 15, 2011
    • Starting with SQL Server 2005 there is no longer guaranteed a session id <= 50 for system processes. 
      It is better to filter user processes using the is_user_process column.
      (is_user_process = 1)
    • Which version of SQL Server are you using? (Just curious.) Thanks!