Browse by Tags

All Tags » tsql » transaction » locks (RSS)
TSQL to identify the transaction with the most locks
Published 31 July 7 9:25 AM | SSQA.net
SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...( read more ) Read More...
Filed under: , , , ,