Hint

Swipe to navigate through the chapters of this book

2016 | OriginalPaper | Chapter

20. Lock Escalation

Author: Dmitri Korotkevitch

Publisher: Apress

Published in: Pro SQL Server Internals

» Get access to the full version

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.

Please log in to get access to this content

To get access to this content you need the following product:

Computer Science Explorer

Purchase now

Title

Lock Escalation

Book

Pro SQL Server Internals

Print ISBN: 978-1-4842-1963-8

Electronic ISBN: 978-1-4842-1964-5

https://doi.org/10.1007/978-1-4842-1964-5

DOI

https://doi.org/10.1007/978-1-4842-1964-5_20

Author:

Dmitri Korotkevitch

Publisher

Apress

Sequence number

Chapter number

Chapter 20