|
What is lock escalation?- Lock escalation is the process of converting low level locks (row locks, page locks) into higher level locks (table locks).
- Each lock is a memory structure. Too many locks mean more memory being occupied by locks.
- SQL Server escalates the many fine-grain locks to fewer coarse-grain locks.
- Lock escalation means the conversion of a lock to a more restrictive mode.
- When lock escalation occurs, the lock is selected for the heap or index is strong enough to meet the requirements of the most restrictive lower level lock.
|
