Abstract
Optimistic transaction isolation levels were introduced in SQL Server 2005 as a new way to deal with blocking problems and to address data consistency issues. As opposed to pessimistic transaction isolation levels, with optimistic transaction isolation levels, queries read “old” committed versions of rows while accessing the data modified by the other sessions, rather than being blocked by the incompatibility of shared (S) and exclusive (X) locks.
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
Rights and permissions
Copyright information
© 2014 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2014). Optimistic Isolation Levels. In: Pro SQL Server Internals. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5963-3_21
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5963-3_21
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-5962-6
Online ISBN: 978-1-4302-5963-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books