O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required