Snapshot Isolation Level - PowerPoint PPT Presentation
1 / 3
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
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
