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
Повратне информације
https://aka.ms/ContentUserFeedback.
Стиже ускоро: Током 2024. године постепено ћемо укидати проблеме са услугом GitHub као механизам повратних информација за садржај и заменити га новим системом повратних информација. За додатне информације, погледајте:Пошаљите и прегледајте повратне информације за