Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Transactions Data Columns

SQL Server 2000

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.

See Also

Transactions Event Category

Transactions Event Classes

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.