dm_db_xtp_transactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
node_id smallint 2 null
xtp_transaction_id bigint 8 null
transaction_id bigint 8 null
session_id smallint 2 null
begin_tsn bigint 8 null
end_tsn bigint 8 null
state int 4 null
state_desc nvarchar 32 null
result int 4 null
result_desc nvarchar 48 null
xtp_parent_transaction_node_id smallint 2 null
xtp_parent_transaction_id bigint 8 null
last_error int 4 null
is_speculative bit 1 null
is_prepared bit 1 null
is_delayed_durability bit 1 null
memory_address varbinary 8 null
database_address varbinary 8 null
thread_id int 4 null
read_set_row_count int 4 null
write_set_row_count int 4 null
scan_set_count int 4 null
savepoint_garbage_count int 4 null
log_bytes_required bigint 8 null
count_of_allocations int 4 null
allocated_bytes int 4 null
reserved_bytes int 4 null
commit_dependency_count int 4 null
commit_dependency_total_attempt_count int 4 null
scan_area int 4 null
scan_area_desc nvarchar 32 null
scan_location int 4 null
dependent_1_address varbinary 8 null
dependent_2_address varbinary 8 null
dependent_3_address varbinary 8 null
dependent_4_address varbinary 8 null
dependent_5_address varbinary 8 null
dependent_6_address varbinary 8 null
dependent_7_address varbinary 8 null
dependent_8_address varbinary 8 null

Relationships

Close relationships within degrees of separation