SQL Server Aggregator : TSQL to identify the transaction with the most locks

Home
Blogs
Forums

SQL Server Aggregator

TSQL to identify the transaction with the most locks

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...

Published Wednesday, August 01, 2007 12:25 AM by SSQA.net

Filed under: SQL Server, performance, tsql, locks, transaction

Anonymous comments are disabled

Subscribe to this blog

Navigation

SQL Server Blog
SQL Server Aggregator
Home
Contact

SQL Server Aggregator

TSQL to identify the transaction with the most locks

Navigation

Tags

Archives