Design Locking and Granularity levels Flashcards Preview

70-464 Certification > Design Locking and Granularity levels > Flashcards

Flashcards in Design Locking and Granularity levels Deck (7)
Loading flashcards...
1

What does lock escalation always escalate to?

Table Lock

2

What does lock escalation never escalate to?

page lock

3

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

4

How can you disable lock escalation?

Enable trace flag 1211

5

How does SQL Server determine which transaction to kill in a deadlock scenario?

Deadlock Priority
Rollback Cost

6

What is Deadlock Priority?

The number given to a transaction to show it's importance to complete the transaction

7

What is Rollback Cost?

If two transactions have the same priority, then SQL determines the lowest cost to roll back and kills that session.