Lock Escalation

Difficulty: Advanced

Question

What is Lock Escalation?

Answer

When a database converts many fine-grained locks (like row locks) into a single coarse-grained lock (like a table lock) to save memory.

Concepts covered

Memory, Locking