© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_17

17. Lock Types and Transaction Isolation Levels

Dmitri Korotkevitch

(1)Tampa, Florida, USA

The concurrency model is, perhaps, the least understood part of SQL Server internals. It can often be confusing; you can encounter hard-to-explain blocking issues in almost every SQL Server installation. Internally, however, the SQL Server concurrency model is based on several well-defined principles, which we are going to discuss in this part of the book.

This chapter starts with the key concept of SQL Server concurrency locks. It will provide an overview of the major lock types in SQL Server, explain their compatibility, and, finally, demonstrate how different ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.