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 either disable lock escalation or enable it for a partitioned table. I’ll demonstrate the snapshot isolation level, as well as Dynamic Management Views (DMVs), which are used to monitor and troubleshoot blocking and locking.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Jason Brimhall, Jonathan Gennick, and Wayne Sheffield
About this chapter
Cite this chapter
Brimhall, J., Gennick, J., Sheffield, W. (2015). Chapter 12: Transactions, Locking, Blocking, and Deadlocking. In: SQL Server T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0061-2_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0061-2_12
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0062-9
Online ISBN: 978-1-4842-0061-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books