
USE tempdb -- use your database
GO

-- sys.databases
-- Contains information about the state of snapshot isolation and whether read committed snapshot is on.
SELECT * FROM sys.databases

-- sys.dm_tran_top_version_generators
-- Tables with most versions
SELECT * FROM sys.dm_tran_top_version_generators

-- sys.dm_tran_transactions_snapshot
-- Version number when a SNAPSHOT transaction started
SELECT * FROM sys.dm_tran_transactions_snapshot

-- sys.dm_tran_active_snapshot_database_transactions
-- Includes information about SNAPSHOT transaction (or not), if SNAPSHOT includes information about version chains and SNAPSHOT timestamps
SELECT * FROM sys.dm_tran_active_snapshot_database_transactions

-- sys.dm_tran_version_store
-- Displays information about all records in the version store
SELECT * FROM sys.dm_tran_version_store