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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for