Category: MSSQL

MSSQL: Session and Request info, Blocking sessions

Naveen Nayak September 17, 2018 No Comments MSSQL, Tips and Tricks

Here is a list of queries that can be helpful if you are trying to troubleshoot locks and blocking sessions on SQL server. — to get session and connections on the server SELECT * FROM sys.dm_exec_sessions AS sess JOIN sys.dm_exec_connections AS conn ON ( sess.session_id = conn.session_id ); — another command to see details EXEC […]

Page 1 of 1