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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho