Shows data related to DTC (Distributed Transaction Coordinator) performance.
Tip: The DTC Details page provides additional data on SQL Server transactions. If the server that Spotlight Enterprise is currently connected to has more than one instance running then details reported in this page are for all instances of SQL Server on the current machine, not only the instance currently under analysis.
Aborted Transactions
The number of distributed transactions that were rolled back.
Active Transactions
The number of distributed transactions that are currently active.
Committed Transactions/sec
The number of distributed transactions that are committed per second.
In Doubt Transactions
Transactions that have passed phase 1 of the two phase commit (have committed the local transaction), and are awaiting a response from the DTC to either commit or rollback (phase 2).
Response time Average
The average time difference between the Begin transaction and the corresponding Commit transaction.
Transactions/sec
The number of distributed transactions performed per second.