Redigera

Dela via


sys.dm_tran_distributed_transaction_stats (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Managed Instance

Returns information about MSDTC statistics in SQL Server.

Table returned

Column name Data type Description
aborted int The number of transactions that were shut down before they were completed.
aborted_max int The highest number of aborted transactions since DTC last started.
forced_abort int The number of aborted transactions that were manually shut down before they were completed.
committed int The number of committed transactions for the instance.
committed_max int The highest number of committed transactions since DTC last started.
forced_commit int The number of committed transactions that were manually committed.
heuristic int TBD
heuristic_max int TBD
in_doubt int The number of in doubt transactions.
in_doubt_max int The highest number of in doubt transactions since DTC last started.
open int The number of running transactions for the instance.
open_max int The highest number of concurrently running transactions since DTC last started.
single_phase_in_doubt int TBD

Permissions

Requires VIEW SERVER PERFORMANCE STATE permission.

Remarks

This view will always return one row with statistics data.

See also