Skip to content
Archive of posts filed under the Concurrency category.

Turn On Snapshot Isolation to Use Version Store

19 June 2009, 8:07 pm

The following statement turns snapshot isolation on:

ALTER DATABASE sqlserverplanet
SET ALLOW_SNAPSHOT_ISOLATION ON
GO
ALTER DATABASE sqlserverplanet
SET READ_COMMITTED_SNAPSHOT ON

Once snapshot isolation is on, rows that have been modified will fill the version store. To find the amount of space the version store is using, execute:

SELECT version_store_in_kb = version_store_reserved_page_count*8192/1024
FROM sys.dm_db_file_space_usage

Filed under Concurrency. Tagged 
Comments