What is Deadlock in SQL Server ?

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has.

In SQL Server when a Deadlock situation occurs it select the processes which have the least overhead to rollback to abort. This way deadlock is automatically resolved. There are multiple ways to identify deadlock i.e. Profile Deadlock Graph, DMV - sys.dm_tran_locks, Extended Events.



You May Interest

What is Failover Clustering in SQL Server ?

What is the Bookmark Lookup and RID Lookup in SQL Server ?

What are the INTERSECT Operators in SQL Server ?

Using CASE WHEN in MS SQL

Finding Session Id in MS SQL User's Current Process