sys-dm-tran-active-transactions-transact-sql.md

description	sys.dm_tran_active_transactions (Transact-SQL)
title	sys.dm_tran_active_transactions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/30/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	reference
f1_keywords	sys.dm_tran_active_transactions sys.dm_tran_active_transactions_TSQL dm_tran_active_transactions_TSQL dm_tran_active_transactions
dev_langs	TSQL
helpviewer_keywords	sys.dm_tran_active_transactions dynamic management view
ms.assetid	154ad6ae-5455-4ed2-b014-e443abe2c6ee
author	WilliamDAssafMSFT
ms.author	wiassaf
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_tran_active_transactions (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

Returns information about transactions for the instance of [!INCLUDEssNoVersion].

Note

To call this from [!INCLUDEssSDWfull] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_tran_active_transactions.

Column Name	Data Type	Description
transaction_id	bigint	ID of the transaction at the instance level, not the database level. It is only unique across all databases within an instance but not unique across all server instances.
name	nvarchar(32)	Transaction name. This is overwritten if the transaction is marked and the marked name replaces the transaction name.
transaction_begin_time	datetime	Time that the transaction started.
transaction_type	int	Type of transaction. 1 = Read/write transaction 2 = Read-only transaction 3 = System transaction 4 = Distributed transaction
transaction_uow	uniqueidentifier	Transaction unit of work (UOW) identifier for distributed transactions. MS DTC uses the UOW identifier to work with the distributed transaction.
transaction_state	int	0 = The transaction has not been completely initialized yet. 1 = The transaction has been initialized but has not started. 2 = The transaction is active. 3 = The transaction has ended. This is used for read-only transactions. 4 = The commit process has been initiated on the distributed transaction. This is for distributed transactions only. The distributed transaction is still active but further processing cannot take place. 5 = The transaction is in a prepared state and waiting resolution. 6 = The transaction has been committed. 7 = The transaction is being rolled back. 8 = The transaction has been rolled back.
transaction_status	int	[!INCLUDEssInternalOnly]
transaction_status2	int	[!INCLUDEssInternalOnly]
dtc_state	int	Applies to: [!INCLUDEssSDSfull] (Initial release through current release). 1 = ACTIVE 2 = PREPARED 3 = COMMITTED 4 = ABORTED 5 = RECOVERED
dtc_status	int	[!INCLUDEssInternalOnly]
dtc_isolation_level	int	[!INCLUDEssInternalOnly]
filestream_transaction_id	varbinary(128)	Applies to: [!INCLUDEssSDSfull] (Initial release through current release). [!INCLUDEssInternalOnly]
pdw_node_id	int	Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW] The identifier for the node that this distribution is on.

Permissions

On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account or the Azure Active Directory admin account is required. On all other SQL Database service objectives, the VIEW DATABASE STATE permission is required in the database.

See Also

sys.dm_tran_session_transactions (Transact-SQL)
sys.dm_tran_database_transactions (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
Transaction Related Dynamic Management Views and Functions (Transact-SQL)