Browse by Tags

• blocking
• deletes
• indexes
• insert
• security
• transaction
• tsql

TSQL to findout blocking and locks on a SQL Server?
07 December 07 12:08 PM | SQL Master | 2 Comments   

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly Read More...

Filed under: tsql, sql server, performance, indexes, security, blocking, locks, deletes, insert

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

Filed under: tsql, sql server, performance, transaction, locks