Browse by Tags

TSQL to identify the transaction with the most locks
31 July 07 07:25 AM | SQL Master | 3 Comments   
SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC Read More...