03 – Deadlocks (18m)

Now that we’ve covered the basics of locking and lock escalation, now let’s escalate (ha!) to deadlocks. Deadlocks are like the Mexican standoff scene in Reservoir Dogs: everybody’s got their guns pointed at each other, and nobody can make progress. SQL Server wakes up every 5 seconds, finds that situation, and draws its own gun,...