SQL Server Locks Question:
Download Job Interview Questions and Answers PDF
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.
Download MS SQL Server Locks Interview Questions And Answers
PDF
Previous Question | Next Question |
What is Optimistic concurrency? | What is SQL Server locking? |