SQL Server Locks Question:

Download Job Interview Questions and Answers PDF

Explain what is lock escalation and what is its purpose?

MS SQL Server Locks Interview Question
MS SQL Server Locks Interview Question

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.

Download MS SQL Server Locks Interview Questions And Answers PDF

Previous QuestionNext Question
What is Optimistic concurrency?What is SQL Server locking?