SQL Server Performance

TSQL to identify the transaction with the most locks

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 31, 2007.

  1. Anonymous New Member

    SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/07/31/1196.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1196" width="1" height="1">

Share This Page