Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.
Finding the Indexes Behind Lock Waits With Operational Stats
Rank indexes behind lock waits with operational stats, separate latches from locks, and test targeted access or row versioning fixes.
SQL SERVER – Reduce Deadlock for Important Transactions With Minimum Code Change
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts
Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.
Reading Deadlock Graphs From the system_health Session
Read deadlock graphs from system_health, identify victims and resource owners, reproduce a two-session cycle, and choose a targeted fix.
Application Locks With sp_getapplock: One Job at a Time
Use sp_getapplock to serialize a job, compare transaction and session ownership, handle return codes, and inspect a two-session test.
Counting Locks per Session With sys.dm_tran_locks
Count locks per session by resource and mode, connect open transactions, and recognize escalation while keeping snapshot limits clear.