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.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-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 caps.latest.revision: 39 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "On Demand" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-all-md]
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. |
On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md], requires the VIEW DATABASE STATE permission in the database.
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)