Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog
Try Out the Latest Microsoft Technology

Quick access

My contributions

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!