Lock-Related Wait Types

  • Enrico van de Laar


Locking is a fundamental part of every relational database, or Relational Database Management System (RDBMS). SQL Server is based on the relational database model, and as such uses locking when data is accessed. Even though we frequently relate locking to performance problems, it plays a vital role in making sure your data is reliable during concurrent workloads. The way SQL Server, or any other RDBMS for that matter, takes care of this data reliability is by following the “ACID” properties, which were originally defined by Jim Gray in the 1970s but received their name in 1983 from Andreas Reuter and Theo Härder. These ACID properties are enforced upon single operations, which we know as transactions. The acronym ACID consists of four characteristics that guarantee data reliability inside transactions. The list below describes each of these characteristics.


Query Plan Intent Share Deadlock Situation Lock Mode Snapshot Isolation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-1139-7_7_MOESM1_ESM.zip (1 kb)
978-1-4842-1140-3_ch07.zip (zip 1 kb)

Copyright information

© Enrico van de Laar 2015

Authors and Affiliations

  • Enrico van de Laar
    • 1
  1. 1.De NijverheidDrachtenThe Netherlands

Personalised recommendations