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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Peter A Carter
About this chapter
Cite this chapter
Carter, P.A. (2015). Locking and Blocking. In: Pro SQL Server Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0710-9_18
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0710-9_18
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0711-6
Online ISBN: 978-1-4842-0710-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books