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:

SQL Serer Page Types

How to find Sql Server Port

SQL Server architecture ( Interview )