sys.dm_db_xtp_transactions (Transact-SQL)

APPLIES TO: YesSQL Server YesAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

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)