sys.dm_tran_active_transactions
Returns information about transactions for the SQL Server instance.
| 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(64) |
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 |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
transaction_status2 |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
dtc_state |
int |
1 = ACTIVE 2 = PREPARED 3 = COMMITTED 4 = ABORTED 5 = RECOVERED |
dtc_status |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
dtc_isolation_level |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
Permissions
Requires VIEW SERVER STATE permission on the server.
See Also
Reference
sys.dm_tran_session_transactions
sys.dm_tran_database_transactions
Dynamic Management Views and Functions
Transaction Related Dynamic Management Views and Functions