Transaction Statistics

The Transaction Statistic window displays statistics on the transactions in which a computer participates. Some of the statistics are cumulative; others reflect current performance.

See the following topics for an overview of managing transactions:

You can use the Transaction Statistics window for the following tasks:

Note that you are using the MTS Explorer on Windows NT, you can only open one Transaction Statistics window for a given server.

Current

Active — The current number of transactions that have not yet completed the two-phase commit protocol.
Max. Active — The highest number of active transactions at any time during the current Microsoft Distributed Transaction Coordinator (MS DTC) session.
In Doubt — The current number of transactions that are unable to commit because of a communication failure between the local database server and the commit coordinator.

Aggregate

Committed — The cumulative total of committed transactions. This number does not include forced (manually resolved) commits.
Aborted — The cumulative total of aborted transactions. This number does not include forced aborts.
Forced Commit — The cumulative total of manually committed transactions.
Forced Abort — The cumulative total of transactions that were manually aborted.
Total — The cumulative total of all transactions.

Response Times

This group shows the minimum, average, and maximum transaction response times in milliseconds. The response time is the duration of a transaction from the point when it began to the point when it was committed.

MS DTC Started/MS DTC Stopped

This group shows the date and time that the current MS DTC session started. The date and time started will not appear unless MS DTC is started. The group will also show that MS DTC is stopped.

Some statistics are cumulative; others reflect current performance.

When you stop the MS DTC service, the values of all cumulative statistics are reset to zero.

See Also

Managing MS DTC