What is lock escalation in databases?

Lock escalation converts many fine-grained locks into a larger lock (like table-level).

When a transaction acquires many row-level or page-level locks, the database may escalate them into a table-level lock to reduce memory overhead. While this improves lock management efficiency, it reduces concurrency and can block other transactions.