SQL Server: 8 different ways to Detect a DeadLock in a Database

In the previous post, I shared T-SQL script to generate a DeadLock situation in SQL Server Database. In this post, I am sharing different scripts to detect a Deadlock in SQL Server. 1. Using SP_LOCK, you can find the WAIT status for blocking sessions: [crayon-680a9c9b2c2dc322553073/] 2. Using sys.sysprocesses: [crayon-680a9c9b2c2e4887730540/] 3. Using common DMV: [crayon-680a9c9b2c2e6120460321/] 4. … Continue reading SQL Server: 8 different ways to Detect a DeadLock in a Database