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
Archive of posts filed under the Concurrency category.
