2016 | OriginalPaper | Chapter
20. Lock Escalation
Published in:
Pro SQL Server Internals
Abstract
Although row-level locking is great from a concurrency standpoint, it is expensive. In memory, a lock structure uses 64 bytes in 32-bit and 128 bytes in 64-bit operating systems. Keeping information about millions of row- and page-level locks would require SQL Server to allocate gigabytes of RAM to storing them.