Flashcards in Design Locking and Granularity levels Deck (7)
What does lock escalation always escalate to?
What does lock escalation never escalate to?
What happens if a transaction attempts to escalate a lock but is unable to because there is an incompatible lock on the table?
It attempts to acquire locks at its original more granular level (row, key, page) periodically while checking for escalated locks
How can you disable lock escalation?
Enable trace flag 1211
How does SQL Server determine which transaction to kill in a deadlock scenario?
What is Deadlock Priority?
The number given to a transaction to show it's importance to complete the transaction