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.