Skip to content

transactions-event-category.md

Latest commit

 

History

History
40 lines (36 loc) · 3.63 KB

transactions-event-category.md

File metadata and controls

40 lines (36 loc) · 3.63 KB
title Transactions Event Category | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.reviewer
ms.technology supportability
ms.topic conceptual
helpviewer_keywords
SQL Server event classes, Transactions event category
event classes [SQL Server], Transactions event category
Transactions event category [SQL Server]
ms.assetid bfc75c5b-7115-49d8-9148-a0c84ee66a9a
author stevestein
ms.author sstein
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Transactions Event Category

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] 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.