seniorT-SQL
What is blocking vs deadlocking in SQL Server?
Updated May 17, 2026
Short answer
Blocking is waiting for locks; deadlock is a circular wait condition.
Deep explanation
Blocking occurs when one transaction holds a lock and another waits. Deadlock is a cycle where two or more transactions wait on each other indefinitely. SQL Server resolves deadlocks by killing a victim transaction.
Unlock with a Pro subscription to view this section.
View pricingReal-world example
No real-world example available yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProCommon mistakes
No common mistakes listed yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProFollow-up questions
No follow-up questions available yet.
Unlock with a Pro subscription to view this section.
Upgrade to Pro