Microsoft KB Archive/45548: Difference between revisions
(importing KB archive) |
(No difference)
|
Latest revision as of 17:56, 18 July 2020
The information in this article applies to:
SQL Server cannot detect deadlocks by simple timeout. SQL Server keeps track of which locks belong to which processes. When a request for a lock is blocked by another process that already holds a lock on that object, SQL Server checks to see if that other process is waiting for a lock that belongs to this process. In fact, it checks all waiting processes so that even transitive deadlocks are detected. Keywords : kbusage SSrvServer |
Last Reviewed: March 6, 1999 |