Snapshot Isolation Level - PowerPoint PPT Presentation

1 / 3
About This Presentation
Title:

Snapshot Isolation Level

Description:

Snapshot Isolation Level. Back-Office Solutions. Berrie Roelofs. www.back-office.nl ... Connection property: SET TRANSACTION ISOLATION LEVEL SNAPSHOT. Properties ... – PowerPoint PPT presentation

Number of Views:33
Avg rating:3.0/5.0
Slides: 4
Provided by: graemem7
Category:

less

Transcript and Presenter's Notes

Title: Snapshot Isolation Level


1
Snapshot Isolation Level
2
ORACLE-like Reads
  • Consistent versions of data are kept in tempdb
  • Enables repeatable reads without blocking other
    users

tempdb
3
Properties
Database property
ALTER DATABASE AdventureWorks SET
ALLOW_SNAPSHOT_ISOLATION ON
Connection property
SET TRANSACTION ISOLATION LEVEL SNAPSHOT
Write a Comment
User Comments (0)
About PowerShow.com