How is Deadlock Different From a Blocking Situation in SQL Server ?

A deadlock occurs when two or more tasks permanently block each other by having a lock on a resource that the other tasks are trying to lock. In a deadlock situation, both transactions in the deadlock will wait forever unless the deadlock is broken while in a standard blocking scenario, the blocked task will simply wait until the blocking task releases the conflicting lock scenario.



You May Interest

Getting List of MS SQL User-Created Tables

What are the Limitations of Indexed Views in SQL Server ?

How is Auditing Different From Change Data Capture in SQL Server?

What is Central Management in SQL Server ?

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...