Optimistic Isolation Levels

  • Dmitri Korotkevitch
Chapter
First Online:

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. 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.

Keywords

Index Fragmentation Active Transaction Cleanup Task Snapshot Isolation Isolation Level 
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.
This is a preview of subscription content, log in to check access

Copyright information

© Dmitri Korotkevitch 2016

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.TampaUSA

Personalised recommendations