What is lock escalation?Lock escalation are used to convert row locks and page locks into table locks thereby “escalating” the smaller or finer locks. This increases the system performance as each lock is nothing but a memory structure. Too many locks would mean more consumption of memory. Hence, escalation is used.What is lock escalation?Lock escalation from SQL Server 7.0 onwards, is dynamically managed by SQL Server. It is the process of converting a lot of low level locks into higher level locks.
|