Turn On Snapshot Isolation to Use Version Store

The following statement turns snapshot isolation on:

[cc lang=”sql”]
ALTER DATABASE sqlserverplanet
SET ALLOW_SNAPSHOT_ISOLATION ON
GO
ALTER DATABASE sqlserverplanet
SET READ_COMMITTED_SNAPSHOT ON
[/cc]

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:

[cc lang=”sql”]
SELECT version_store_in_kb = version_store_reserved_page_count*8192/1024
FROM sys.dm_db_file_space_usage
[/cc]

Featured Articles

 Site Author

  • Thanks for visiting!
css.php