Showing posts with label Dead Lock. Show all posts
Showing posts with label Dead Lock. 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:
Subscribe to:
Posts (Atom)