| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_tran_distributed_transaction_stats (Transact-SQL) |
sys.dm_tran_distributed_transaction_stats (Transact-SQL) |
VanMSFT |
vanto |
02/24/2023 |
sql |
system-objects |
reference |
|
>=sql-server-ver16||>=sql-server-linux-ver16||=azuresqldb-mi-current |
[!INCLUDE SQL Server 2022 Azure SQL Managed Instance]
Returns information about MSDTC statistics in SQL Server.
| 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 |
Requires VIEW SERVER PERFORMANCE STATE permission.
This view will always return one row with statistics data.