Skip to content

Latest commit

 

History

History
38 lines (34 loc) · 3.54 KB

transactions-event-category.md

File metadata and controls

38 lines (34 loc) · 3.54 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Transactions Event Category
Transactions Event Category
WilliamDAssafMSFT
wiassaf
03/14/2017
sql
supportability
reference
SQL Server event classes, Transactions event category
event classes [SQL Server], Transactions event category
Transactions event category [SQL Server]
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Transactions Event Category

[!INCLUDE 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 [!INCLUDEmsCoName] Distributed Transaction Coordinator (MS DTC). These are transactions distributed between two or more databases or instances of the [!INCLUDEssDEnoversion].
SQLTransaction Event Class Tracks [!INCLUDEtsql] 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.