Динамические административные представления и функции, связанные с транзакциями (Transact-SQL)Transaction Related Dynamic Management Views and Functions (Transact-SQL)

ОБЛАСТЬ ПРИМЕНЕНИЯ: даSQL Server нетБаза данных SQL Azure нетAzure Synapse Analytics (хранилище данных SQL) нетParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Этот раздел содержит следующие объекты DMO.This section contains the following dynamic management objects.

sys.dm_tran_active_snapshot_database_transactions (Transact-SQL)sys.dm_tran_active_snapshot_database_transactions (Transact-SQL) sys.dm_tran_active_transactions (Transact-SQL)sys.dm_tran_active_transactions (Transact-SQL)
sys.dm_tran_current_snapshot (Transact-SQL)sys.dm_tran_current_snapshot (Transact-SQL) sys.dm_tran_current_transaction (Transact-SQL)sys.dm_tran_current_transaction (Transact-SQL)
sys.dm_tran_database_transactions (Transact-SQL)sys.dm_tran_database_transactions (Transact-SQL) sys.dm_tran_locks (Transact-SQL)sys.dm_tran_locks (Transact-SQL)
sys.dm_tran_session_transactions (Transact-SQL)sys.dm_tran_session_transactions (Transact-SQL) sys.dm_tran_top_version_generators (Transact-SQL)sys.dm_tran_top_version_generators (Transact-SQL)
sys.dm_tran_transactions_snapshot (Transact-SQL)sys.dm_tran_transactions_snapshot (Transact-SQL) sys.dm_tran_version_store (Transact-SQL)sys.dm_tran_version_store (Transact-SQL)
sys.dm_tran_version_store_space_usagesys.dm_tran_version_store_space_usage