Scans Data Columns

Administering SQL Server

previous page next page
Administering SQL Server

Scans Data Columns

The following table lists the data columns for each event class in the Scans event category.

Event class Data column Description
Scan: Started Event Class Type of event recorded = 51.
  Mode Scan mode. Can have these values:

1 = Normal
2 = First
4 = Back
8 = Unordered
16 = No data
32 = Reserved
64 = Exlatch
128 = Index supplied
256 = Marker
  Object ID ID of the object that is being scanned.
  Index ID ID of the index, if an index is being scanned.
  Transaction ID ID of the transaction of which the scan is a part.
Scan: Stopped Event Class Type of event recorded = 52.
  Mode Mode that was used to perform the scan. Can have these values:

1 = Normal
2 = First
4 = Back
8 = Unordered
16 = No data
32 = Reserved
64 = Exlatch
128 = Index supplied
256 = Marker
  End Time End time of the event.
  Duration Duration of the scan.
  Reads Number of logical pages read.
  Index ID ID of the index, if an index is being scanned.
  Object ID ID of the object that is being scanned.

By monitoring the Index ID default data column, you can determine the identification number of the index being used by a specific query. The Index ID data column contains either:

  • The value 1 when the clustered index of the table is being scanned.

    -or-

  • The value greater than 2 and less than 255 when a non-clustered index of the table is being scanned.

See Also

Scans Event Category

Scans Event Classes

previous page start next page