What is lock escalation?



What is lock escalation?..

Answer / swapna

Lock escalation is the process of converting a lot of low
level locks (like row locks, page locks) into higher level
locks (like table locks). Every lock is a memory structure
too many locks would mean, more memory being occupied by
locks.

To prevent this from happening, SQL Server escalates the
many fine-grain locks to fewer coarse-grain locks. Lock
escalation threshold was definable in SQL Server 6.5, but
from SQL Server 7.0 onwards it's dynamically managed by SQL
Server.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How you can change a cross join into an inner join?

0 Answers  


How to use group functions in the select clause in ms sql server?

0 Answers  


How to create a large table with random data for index testing in ms sql server?

0 Answers  


Differentiate between mongodb vs. Sql server?

0 Answers  


Explain why variables called the most powerful component of ssis?

0 Answers  






What is the difference between left and right outer join?

0 Answers  


internal language used in sql server 2000?

2 Answers  


What is raid, and how it can influence database performance?

0 Answers  


What is the difference between a fill factor of 100 and 0?

0 Answers  


What are the different SQL Server Versions you have worked on?

0 Answers  


What is difference statement and preparedstatement?

0 Answers  


What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  


Categories