Optimistic Isolation Levels

  • Dmitri Korotkevitch


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.


Index Fragmentation Active Transaction Cleanup Task Isolation Level Referential Integrity 
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

© Dmitri Korotkevitch 2014

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.FLUnited States

Personalised recommendations