Home
Blogs
Forums
Browse by Tags
All Tags
»
performance
»
tsql
»
transaction
locks
SQL Server
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)
Posted to
SQL Server Aggregator
(Weblog)
by
Anonymous
on
August 1, 2007
Copyright © 2008 wardyit.com. All rights reserved.