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 1 = PROPAGATE_XACT_SUB_CLASS 2 = DOWORK_SUB_CLASS 3 = CLOSE_CONN_SUB_CLASS 4 = DTC_VIRGIN_SUB_CLASS 5 = DTC_IDLE_SUB_CLASS 6 = DTC_BEG_DIST_SUB_CLASS 7 = DTC_ENLISTING_SUB_CLASS 8 = DTC_INT_ACTIVE_SUB_CLASS 9 = DTC_INT_COMMIT_SUB_CLASS 10 = DTC_INT_ABORT_SUB_CLASS 11 = DTC_INT_ASYNC_ABORT_SUB_CLASS 12 = DTC_ACTIVE_SUB_CLASS 13 = DTC_INIT_PREPARE_SUB_CLASS 14 = DTC_PREPARING_SUB_CLASS 15 = DTC_PREPARED_SUB_CLASS 16 = DTC_ABORTING_SUB_CLASS 17 = DTC_COMMITTING_SUB_CLASS 18 = DTC_DO_ASYNC_ABORT_SUB_CLASS 19 = DTC_DISASTER_SUB_CLASS 20 = DTC_DRAIN_ABORT_SUB_CLASS 21 = DTC_ASYNC_ABORT_SUB_CLASS 22 = DTC_TM_RECOVERY_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 4096 = Read Committed 65536 = Repeatable read 1048576 = Serializable 4294967295 = Unspecified
	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 1 = Commit Transaction 2 = Rollback Transaction 3 = A Savepoint was issued
	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.

Transactions Data Columns

See Also