Query Processing Events Data Columns

 

Applies To: SQL Server 2016

The Query Processing Events event category has the following event classes:

Event IDEvent NameEvent Description
70Query Cube BeginQuery cube begin.
71Query Cube EndQuery cube end.
72Calculate Non Empty BeginCalculate non empty begin.
73Calculate Non Empty CurrentCalculate non empty current.
74Calculate Non Empty EndCalculate non empty end.
75Serialize Results BeginSerialize results begin.
76Serialize Results CurrentSerialize results current.
77Serialize Results EndSerialize results end.
78Execute MDX Script BeginExecute MDX script begin.
79Execute MDX Script CurrentExecute MDX script current. Deprecated.
80Execute MDX Script EndExecute MDX script end.
81Query DimensionQuery dimension.
11Query SubcubeQuery subcube, for Usage Based Optimization.
12Query Subcube VerboseQuery subcube with detailed information. This event may have a negative impact on performance when turned on.
60Get Data From AggregationAnswer query by getting data from aggregation. This event may have a negative impact on performance when turned on.
61Get Data From CacheAnswer query by getting data from one of the caches. This event may have a negative impact on performance when turned on.
82VertiPaq SE Query BeginVertiPaq SE query
83VertiPaq SE Query EndVertiPaq SE query
84Resource UsageReports reads, writes, cpu usage after end of commands and queries.
85VertiPaq SE Query Cache MatchVertiPaq SE query cache use
98Direct Query BeginDirect Query Begin.
99Direct Query EndDirect Query End.

The following tables list the data columns for each of these event classes.

Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

1: Get Data

2: Process Calculated Members

3: Post Order
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class.

1: Serialize Axes

2: Serialize Cells

3: Serialize SQL Rowset

4: Serialize Flattened Rowset
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

1: MDX Script

2: MDX Script Command
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

1: MDX Script

2: MDX Script Command
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class.

1: Cache data

2: Non-cache data
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

1: Cache data

2: Non-cache data

3: Internal data

4: SQL data

11: Measure Group Structural Change

12: Measure Group Deletion
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

21: Cache data

22: Non-cache data

23: Internal data

24: SQL data
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class.

1: Get data from measure group cache

2: Get data from flat cache

3: Get data from calculation cache

4: Get data from persisted cache
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

0: VertiPaq Scan

1: Tabular Query

2: User Hierarchy Processing Query

10: VertiPaq Scan internal

11: Tabular Query internal

12: User Hierarchy Processing Query internal
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
JobID71Job ID for progress.
SessionType88Session type (what entity caused the operation).
ObjectID118Object ID (note this is a string).
ObjectType121Object type.
ObjectName138Object name.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ObjectReference158Object reference. Encoded as XML for all parents, using tags to describe the object.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class.

0: VertiPaq Scan

1: Tabular Query

10: VertiPaq Scan internal

11: Tabular Query internal
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
JobID71Job ID for progress.
SessionType88Session type (what entity caused the operation).
ProgressTotal91Progress total.
IntegerData101Integer data.
ObjectID118Object ID (note this is a string).
ObjectType121Object type.
ObjectName138Object name.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ObjectReference158Object reference. Encoded as XML for all parents, using tags to describe the object.
Severity221Severity level of an exception.
Success2311 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error241Error number of a given event.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
ClientProcessID361The process ID of the client application.
ApplicationName378Name of the client application that created the connection to the server. This column is populated with the values passed by the application rather than the displayed name of the program.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
EventSubclass11Event Subclass provides additional information about each event class:

0: VertiPaq Cache exact match
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
JobID71Job ID for progress.
SessionType88Session type (what entity caused the operation).
ObjectID118Object ID (note this is a string).
ObjectType121Object type.
ObjectName138Object name.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ObjectReference158Object reference. Encoded as XML for all parents, using tags to describe the object.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
JobID71Job ID for progress.
SessionType88Session type (what entity caused the operation).
IntegerData101Integer data.
ObjectID118Object ID (note this is a string).
ObjectType121Object type.
ObjectName138Object name.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
Severity221Severity level of an exception.
Success2311 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error241Error number of a given event.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
ClientProcessID361The process ID of the client application.
SessionID398Session GUID.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
CPUTime62Amount of CPU time (in milliseconds) used by the event.
JobID71Job ID for progress.
SessionType88Session type (what entity caused the operation).
IntegerData101Integer data.
ObjectID118Object ID (note this is a string).
ObjectType121Object type.
ObjectName138Object name.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
Severity221Severity level of an exception.
Success2311 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error241Error number of a given event.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
ClientProcessID361The process ID of the client application.
SessionID398Session GUID.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.

Query Processing Events Category

Community Additions

ADD
Show: