Редагувати

Поділитися через


Transactions Event Category

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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.