Transactions Data Columns
The following table lists the data columns for each event class in the Transactions event category.
| Event class | Data column | Description |
|---|---|---|
| DTCTransaction | Event Class | Type of event recorded = 19. |
| Event Sub Class | Microsoft® Distributed Transaction Coordinator (MS DTC) state. For more information, see the MS DTC documentation. Possible values include:
0 = GET_DTC_ADDRESS_SUB_CLASS |
|
| End Time | The end time of the event. | |
| Duration | The length of the DTC transaction. | |
| Reads | The number of page reads generated locally by the DTC transaction. | |
| Writes | The number of page writes generated locally by the DTC transaction. | |
| CPU | The amount of CPU used by the DTC transaction. | |
| Integer Data | Transaction isolation level. Possible values are:
256 = Read uncommitted |
|
| Binary Data | Globally unique ID (GUID), in hexadecimal form, of the transaction, if available. For possible values of the Binary Data, see Table 2 below. | |
| SQLTransaction | Event Class | Type of event recorded = 50. |
| Event Sub Class | Type of SQL transaction event. Possible values include:
0 = Begin Transaction |
|
| End Time | The end time of the event. This option is only for a COMMIT or ROLLBACK. | |
| Duration | How long the transaction ran for. This option is only for a COMMIT or ROLLBACK. | |
| Transaction ID | The internal ID number of the transaction. | |
| Text Data | The savepoint or rollback name, if provided. | |
| Object Name | The transaction name, if provided. | |
| TransactionLog | Event Class | Type of event recorded = 54. |
| Event Sub Class | Type of transaction log event, such as BEGINXACT(null). | |
| Integer Data | The length of the log record. | |
| Binary Data | The Replication log_pubid is the publication ID that is currently being worked on. If you are using replication and look in the table for MSPublications there is a column of publication_id. This is the value represented in Binary Data. You can use this ID to find the publication and any articles associated with it. | |
| End Time | The end time of the event. | |
| Reads | The number of read I/Os issued to perform the log entry. | |
| Writes | The number of I/Os issued to perform the log entry. | |
| CPU | The amount of CPU used to write the transaction entry. | |
| Transaction ID | The internal ID number of the transaction. | |
| Object ID | The ID of the object that has logged modifications. | |
| Index ID | The ID of the index that has logged modifications. |