Categories
MSSQL Server

MSSQL Search Blocked Sessions

Query for blocked sessions.

SELECT session_id, status, blocking_session_id FROM sys.dm_exec_requests WHERE blocking_session_id > 0

Close a blocking session.

KILL {blocking_session_id}