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 |
How you can change a cross join into an inner join?
How to use group functions in the select clause in ms sql server?
How to create a large table with random data for index testing in ms sql server?
Differentiate between mongodb vs. Sql server?
Explain why variables called the most powerful component of ssis?
What is the difference between left and right outer join?
internal language used in sql server 2000?
What is raid, and how it can influence database performance?
What is the difference between a fill factor of 100 and 0?
What are the different SQL Server Versions you have worked on?
What is difference statement and preparedstatement?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?