Skip to content

transactions-event-category.md

Latest commit

 

History

History
41 lines (36 loc) · 3.62 KB

transactions-event-category.md

File metadata and controls

41 lines (36 loc) · 3.62 KB
title Transactions Event Category
description Transactions Event Category
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 03/14/2017
ms.service sql
ms.subservice supportability
ms.topic reference
ms.custom
ignite-2025
helpviewer_keywords
SQL Server event classes, Transactions event category
event classes [SQL Server], Transactions event category
Transactions event category [SQL Server]
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

Transactions Event Category

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB] 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.