What is SQL Server lock escalation and how does it work internally?

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

When a transaction acquires many row or page locks, SQL Server escalates them into a table-level lock to reduce memory overhead in the lock manager. This improves scalability but can reduce concurrency. Escalation is triggered by thresholds or memory pressure in the lock manager.