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.databases (Transact-SQL)

sys.dm_tran_top_version_generators

sys.dm_tran_active_snapshot_database_transactions

sys.dm_tran_transactions_snapshot

sys.dm_tran_version_store

sys.dm_tran_current_transaction

sys.dm_tran_current_snapshot

sys.dm_db_file_space_usage

sys.dm_db_session_space_usage

sys.dm_db_task_space_usage

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.

See Also

Concepts

Understanding Row Versioning-Based Isolation Levels
Choosing Row Versioning-based Isolation Levels
Using Row Versioning-based Isolation Levels

Other Resources

SET TRANSACTION ISOLATION LEVEL (Transact-SQL)
ALTER DATABASE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance