Transactions Event Category

The Transactions event classes can be used to monitor the status of transactions. The event class names that are prefixed with TM: are used to track the transaction-related operations that are sent through the transaction management interface.

In This Section

Topic Description

DTCTransaction Event Class

Tracks transactions coordinated by the Microsoft Distributed Transaction Coordinator (MS DTC). These are transactions distributed between two or more databases or instances of the SQL Server Database Engine.

SQLTransaction Event Class

Tracks Transact-SQL BEGIN TRAN, COMMIT TRAN, SAVE TRAN, and ROLLBACK TRAN statements.

TM: Begin Tran Completed Event Class

Indicates that a BEGIN TRANSACTION request has completed.

TM: Begin Tran Starting Event Class

Indicates that a BEGIN TRANSACTION request is starting.

TM: Commit Tran Completed Event Class

Indicates that a COMMIT TRANSACTION request has completed.

TM: Commit Tran Starting Event Class

Indicates that a COMMIT TRANSACTION request is starting.

TM: Promote Tran Completed Event Class

Indicates that a PROMOTE TRANSACTION request has completed.

TM: Promote Tran Starting Event Class

Indicates that a PROMOTE TRANSACTION request is starting.

TM: Rollback Tran Completed Event Class

Indicates that a ROLLBACK TRANSACTION request has completed.

TM: Rollback Tran Starting Event Class

Indicates that a ROLLBACK TRANSACTION request is starting.

TM: Save Tran Completed Event Class

Indicates that a SAVE TRANSACTION request has completed.

TM: Save Tran Starting Event Class

Indicates that a SAVE TRANSACTION request is starting.

TransactionLog Event Class

Tracks when transactions are written to a database transaction log.

See Also

Concepts

Transactions (Database Engine)

Other Resources

Monitoring Events

Help and Information

Getting SQL Server 2005 Assistance