Lock escalation is when the system combines multiple locks into a higher level one. This is done to recover resources taken by the other finer granular locks. The system automatically does this. The threshold for this escalation is determined dynamically by the server.

Purpose:

To reduce system over head by recovering locks

Maximize the efficiency of queries

Helps to minimize the required memory to keep track of locks.