Home
Blogs
Forums
Browse by Tags
All Tags
»
transaction
»
locks
performance
SQL Server
tsql
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.