Showing posts with label SQL Internals. Show all posts
Showing posts with label SQL Internals. Show all posts

How Sql server Deadlock Mechanism works

Deadlock Detection


Note: To enable deadlock , Please refer : How To Enable Deadlock Trace in Sql Server

 Deadlock detection is performed by a lock monitor thread that periodically initiates a search through all of the tasks in an instance of the Database Engine. The following points describe the search process: