Transactions Event Category

Transactions Event Category

 

Applies To: SQL Server 2016

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.

TopicDescription
DTCTransaction Event ClassTracks 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 ClassTracks Transact-SQL BEGIN TRAN, COMMIT TRAN, SAVE TRAN, and ROLLBACK TRAN statements.
TM: Begin Tran Completed Event ClassIndicates that a BEGIN TRANSACTION request has completed.
TM: Begin Tran Starting Event ClassIndicates that a BEGIN TRANSACTION request is starting.
TM: Commit Tran Completed Event ClassIndicates that a COMMIT TRANSACTION request has completed.
TM: Commit Tran Starting Event ClassIndicates that a COMMIT TRANSACTION request is starting.
TM: Promote Tran Completed Event ClassIndicates that a PROMOTE TRANSACTION request has completed.
TM: Promote Tran Starting Event ClassIndicates that a PROMOTE TRANSACTION request is starting.
TM: Rollback Tran Completed Event ClassIndicates that a ROLLBACK TRANSACTION request has completed.
TM: Rollback Tran Starting Event ClassIndicates that a ROLLBACK TRANSACTION request is starting.
TM: Save Tran Completed Event ClassIndicates that a SAVE TRANSACTION request has completed.
TM: Save Tran Starting Event ClassIndicates that a SAVE TRANSACTION request is starting.
TransactionLog Event ClassTracks when transactions are written to a database transaction log.

Community Additions

ADD
Show:
© 2016 Microsoft