Advertisement

Locking and Blocking

  • Peter A Carter

Abstract

Locking is an essential aspect of any RDBMS, because it allows concurrent users to access the same data, without the risk of their updates conflicting and causing data integrity issues. This chapter discusses how locking, deadlocks, and transactions work in SQL Server; it then moves on to discuss how transactions impact SQL Server 2014’s new In-Memory transaction functionality and how the DBA can observe lock metadata regarding transactions and contention.

Keywords

Read Operation Query Window Transaction Level Atomic Block Current Transaction 
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-0710-9_18_MOESM1_ESM.zip (6 kb)
978-1-4842-0711-6_CH18.zip (zip 7 kb)

Copyright information

© Peter A Carter 2015

Authors and Affiliations

  • Peter A Carter
    • 1
  1. 1.BotleyUK

Personalised recommendations