Fonctions et vues de gestion dynamique relatives aux transactions (Transact-SQL)Transaction Related Dynamic Management Views and Functions (Transact-SQL)

CETTE RUBRIQUE S’APPLIQUE À : ouiSQL Server (à partir de la version 2012)nonAzure SQL DatabasenonAzure SQL Data WarehousenonParallel Data Warehouse THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Cette section contient les objets de gestion dynamique suivants.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