Swipe to navigate through the chapters of this book
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.
Please log in to get access to this content
To get access to this content you need the following product:
- Lock Escalation
- Sequence number
- Chapter number
- Chapter 20