Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

View connection and Locking Information

By sql frenzy,

This procedure uses xsp_cmdshell to get the host IP address, hence it is slow to execute depending on the number of process.

The usage is exec usp_GetConnectionInfo

 

Total article views: 2423 | Views in the last 30 days: 4
 
Tags
host ip address    
locking    
sp_lock    
sp_who    
sp_who2    
 
Contribute