Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

What is lock escalation?
Lock escalation is the bassically use for the converting a lot of low level locks like a row lock or the level locks into higher level locks which is 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. 
Posted By: Name:Rajesh Kr URL: What is lock escalation?