Advertisement

Transactions, Locking, Blocking, and Deadlocking

  • Jason Brimhall
  • David Dye
  • Jonathan Gennick
  • Andy Roberts
  • Wayne Sheffield
Chapter

Abstract

In this chapter, I’ll review recipes for handling transactions, lock monitoring, blocking, and deadlocking. I’ll review the SQL Server table option that allows you to disable lock escalation or enable it for a partitioned table. I’ll demonstrate the snapshot isolation level, as well as Dynamic Management Views (DMVs) that are used to monitor and troubleshoot blocking and locking.

Keywords

Resource Type Active Transaction Query Window 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.

Copyright information

© Jason Brimhall 2012

Authors and Affiliations

  • Jason Brimhall
    • 1
  • David Dye
    • 2
  • Jonathan Gennick
    • 3
  • Andy Roberts
    • 4
  • Wayne Sheffield
    • 5
  1. 1.UTUSA
  2. 2.FLUSA
  3. 3.MIUnited States
  4. 4.MAUSA
  5. 5.VAUSA

Personalised recommendations