SQL Server Locks Question:
Explain what is lock escalation and what is its purpose?
Answer:
Lock escalation is when the system combines multiple locks into a higher level one. This is done to recover resources taken by the other finer granular locks. The system automatically does this. The threshold for this escalation is determined dynamically by the server.
Purpose:
To reduce system over head by recovering locks
Maximize the efficiency of queries
Helps to minimize the required memory to keep track of locks.
Purpose:
To reduce system over head by recovering locks
Maximize the efficiency of queries
Helps to minimize the required memory to keep track of locks.
| Previous Question | Next Question |
| What is Optimistic concurrency? | What is SQL Server locking? |