Returns information about transactions at the database level.
|
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.
|
|
database_id
|
int
|
ID of the database associated with the transaction.
|
|
database_transaction_begin_time
|
datetime
|
Time at which the database became involved in the transaction. Specifically, it is the time of the first log record in the database for the transaction.
|
|
database_transaction_type
|
int
|
1 = Read/write transaction
2 = Read-only transaction
3 = System transaction
|
|
database_transaction_state
|
int
|
1 = The transaction has not been initialized.
3 = The transaction has been initialized but has not generated any log records.
4 = The transaction has generated log records.
5 = The transaction has been prepared.
10 = The transaction has been committed.
11 = The transaction has been rolled back.
12 = The transaction is being committed. In this state the log record is being generated, but it has not been materialized or persisted.
|
|
database_transaction_status
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
database_transaction_status2
|
int
|
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
|
|
database_transaction_log_record_count
|
int
|
Number of log records generated in the database for the transaction.
|
|
database_transaction_replicate_record_count
|
int
|
Number of log records generated in the database for the transaction that will be replicated.
|
|
database_transaction_log_bytes_used
|
bigint
|
Number of bytes used so far in the database log for the transaction.
|
|
database_transaction_log_bytes_reserved
|
bigint
|
Number of bytes reserved for use in the database log for the transaction.
|
|
database_transaction_log_bytes_used_system
|
int
|
Number of bytes used so far in the database log for system transactions on behalf of the transaction.
|
|
database_transaction_log_bytes_reserved_system
|
int
|
Number of bytes reserved for use in the database log for system transactions on behalf of the transaction.
|
|
database_transaction_begin_lsn
|
numeric(25,0)
|
Log sequence number (LSN) of the begin record for the transaction in the database log.
|
|
database_transaction_last_lsn
|
numeric(25,0)
|
LSN of the most recently logged record for the transaction in the database log.
|
|
database_transaction_most_recent_savepoint_lsn
|
numeric(25,0)
|
LSN of the most recent savepoint for the transaction in the database log.
|
|
database_transaction_commit_lsn
|
numeric(25,0)
|
LSN of the commit log record for the transaction in the database log.
|
|
database_transaction_last_rollback_lsn
|
numeric(25,0)
|
LSN that was most recently rolled back to. If no rollback has taken place, the value will be MaxLSN (-1:-1:-1).
|
|
database_transaction_next_undo_lsn
|
numeric(25,0)
|
LSN of the next record to undo.
|