sys.dm_db_xtp_transactions (Transact-SQL)
Applies to: 
SQL Server (all supported versions) Azure SQL DatabaseAzure SQL Managed Instance
Reports the active transactions in the In-Memory OLTP database engine.
For more information, see In-Memory OLTP (In-Memory Optimization).
| Column name | Data type | Description |
|---|---|---|
| xtp_transaction_id | bigint | Internal ID for this transaction in the XTP transaction manager. |
| transaction_id | bigint | The transaction ID. Joins with the transaction ID in other transaction-related DMVs, such as sys.dm_tran_active_transactions. 0 for XTP-only transactions, such as transactions started by natively compiled stored procedures. |
| session_id | smallint | The session identifier of the session that is executing this transaction. Joins with sys.dm_exec_sessions. |
| begin_tsn | bigint | Begin transaction serial number of the transaction. |
| end_tsn | bigint | End transaction serial number of the transaction. |
| state | int | The state of the transaction: 0=ACTIVE 1=COMMITTED 2=ABORTED 3=VALIDATING |
| state_desc | nvarchar | The description of the transaction state. |
| result | int | The result of this transaction. The following are the possible values. 0 - IN PROGRESS 1 - SUCCESS 2 - ERROR 3 - COMMIT DEPENDENCY 4 - VALIDATION FAILED (RR) 5 - VALIDATION FAILED (SR) 6 - ROLLBACK |
| result_desc | nvarchar | The result of this transaction. The following are the possible values. IN PROGRESS SUCCESS ERROR COMMIT DEPENDENCY VALIDATION FAILED (RR) VALIDATION FAILED (SR) ROLLBACK |
| last_error | int | Internal use only |
| is_speculative | bit | Internal use only |
| is_prepared | bit | Internal use only |
| is_delayed_durability | bit | Internal use only |
| memory_address | varbinary | Internal use only |
| database_address | varbinary | Internal use only |
| thread_id | int | Internal use only |
| read_set_row_count | int | Internal use only |
| write_set_row_count | int | Internal use only |
| scan_set_count | int | Internal use only |
| savepoint_garbage_count | int | Internal use only |
| log_bytes_required | bigint | Internal use only |
| count_of_allocations | int | Internal use only |
| allocated_bytes | int | Internal use only |
| reserved_bytes | int | Internal use only |
| commit_dependency_count | int | Internal use only |
| commit_dependency_total_attempt_count | int | Internal use only |
| scan_area | int | Internal use only |
| scan_area_desc | nvarchar | Internal use only |
| scan_location | int | Internal use only. |
| dependent_1_address | varbinary(8) | Internal use only |
| dependent_2_address | varbinary(8) | Internal use only |
| dependent_3_address | varbinary(8) | Internal use only |
| dependent_4_address | varbinary(8) | Internal use only |
| dependent_5_address | varbinary(8) | Internal use only |
| dependent_6_address | varbinary(8) | Internal use only |
| dependent_7_address | varbinary(8) | Internal use only |
| dependent_8_address | varbinary(8) | Internal use only |
Permissions
Requires VIEW DATABASE STATE permission on the server.
See Also
Memory-Optimized Table Dynamic Management Views (Transact-SQL)