Finding Deadlocks in SQL Server

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: […]