Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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.