Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag sp_who2 Rss

   Items 1 to 12 of 12   
 

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,897 reads

Capture and Alert for Blocked SPIDS with SP_WHO2

This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.  Read more...
By Joshua A. Walker 2013/12/04 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 3,293 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,897 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,897 reads

Capture and Alert for Blocked SPIDS with SP_WHO2

This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.  Read more...
By Joshua A. Walker 2013/12/04 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 3,293 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,897 reads

What, When, Where, How, Who2

Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.  Read more...
By Jason Brimhall 2010/06/14 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 10,917 reads

View connection and Locking Information

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address   Read more...
By sql frenzy 2010/05/17 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 2,325 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,897 reads

View connection and Locking Information

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address   Read more...
By sql frenzy 2010/05/17 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 2,325 reads

usp_SQL_In_sp_who2

Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID  Read more...
By Banyardi Schmardi 2009/04/24 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 1,156 reads

Indepth SPID information

This SP gives you most of the detail you need on a long running query. Simply pass the SPID.  Read more...
By Amar P 2009/01/09 | Source: SQLServerCentral.com | Category: sp_who2
Rating: (not yet rated) |  Discuss |   Briefcase | 1,889 reads
   Items 1 to 12 of 12   
 
Tags
blocking (2)    
locking (2)    
sp_who (2)    
spid (2)    
activity (1)    
alerts (1)    
current activity (1)    
dbcc inputbuffer (1)    
enhancement (1)    
host ip address (1)    
input buffer (1)    
monitoring (1)    
processes (1)    
sp_lock (1)    
sys.dm_exec_query_plan (1)    
sys.dm_exec_requests (1)    
sys.sysprocesses (1)    
t-sql (1)