Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog

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
  • Hide
    Track_waitstats_2005
    2 Posts | Last post August 31, 2013
    • Written May 16, 2012 
      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
    • Written August 31, 2013 
      I found it locates at here http://gallery.technet.microsoft.com/scriptcenter/8c90bd2e-9def-4f44-bce4-e5dae4d86f71
  • Hide
    Not VB ??
    2 Posts | Last post November 15, 2011
    • Written September 27, 2010 
      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
    • Written November 15, 2011 
      Good catch!
  • Hide
    Testing for user sessions
    2 Posts | Last post November 15, 2011
    • Written December 15, 2010 
      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)
    • Written November 15, 2011 
      Which version of SQL Server are you using? (Just curious.) Thanks!