© Dmitri Korotkevitch 2018
Dmitri KorotkevitchExpert SQL Server Transactions and Lockinghttps://doi.org/10.1007/978-1-4842-3957-5_8

8. Schema and Low-Priority Locks

Dmitri Korotkevitch1 
(1)
Land O Lakes, Florida, USA
 

SQL Server uses two additional lock types called schema locks to prevent table and metadata alterations during query execution. This chapter will discuss schema locks in depth along with low-priority locks, which were introduced in SQL Server 2014 to reduce blocking during online index rebuilds and partition switch operations.

Schema Locks

SQL Server needs to protect database metadata in order to prevent situations where a table’s structure is changed in the middle of query execution. The problem is more complicated than it seems. Even ...

Get Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners now with O’Reilly online learning.

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