Browse by Tags

All Tags » transaction   (RSS)
SQL Server: Quick way to find Active & idle connections on a SQL instance
02 May 08 02:32 AM | SQL Master | 2 Comments   
Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system Read More...
TSQL to identify the transaction with the most locks
31 July 07 07:25 AM | SQL Master | 3 Comments   
SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC Read More...