Finding Deadlocks in SQL Server

SQL Server Database Services Icon

QUICK RECAP – WHAT IS A DEADLOCK? Deadlocks occur in SQL Server when two (or more) processes are waiting to acquire a resource (such as a lock) that is currently held be the other. Neither can continue because it is blocked by the other process, so you get a deadlock. The diagram below illustrates this: […]