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
Add to favorites
E-mail Twitter Digg Facebook
  • Track_waitstats_2005
    2 Posts | Last post August 31, 2013
    • The article,, 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. 
    • I found it locates at here
  • 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.
    • 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!