Displaying Row Versioning Information
The Microsoft SQL Server Database Engine provides database administrators and programmers with the following mechanisms for displaying row versioning information.
Transact-SQL Functions and Views
The following system catalog views or system functions return information relating to row versioning:
sys.dm_tran_top_version_generators (Transact-SQL)
sys.dm_tran_active_snapshot_database_transactions (Transact-SQL)
sys.dm_tran_transactions_snapshot (Transact-SQL)
sys.dm_tran_version_store (Transact-SQL)
sys.dm_tran_current_transaction (Transact-SQL)
sys.dm_tran_current_snapshot (Transact-SQL)
sys.dm_db_file_space_usage (Transact-SQL)
Performance Counters
Information about row versioning is presented in several counters of the SQL Server: Transactions Object in the System Monitor. For more information, see SQL Server, Transactions Object and Row Versioning Resource Usage.