Locks by SPID

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

SELECT request_session_id, COUNT (*) num_locks
FROM sys.dm_tran_locks
GROUP BY request_session_id
ORDER BY count (*) DESC