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