Query Processing Events Category

 

Applies To: SQL Server 2016

The Query Processing event category has the event classes described in the following table.

Event ClassEvent IdDescription
Query Subcube11Query subcube, for Usage Based Optimization.
Query Subcube Verbose12Query subcube with detailed information. This event may have a negative impact on performance when turned on.
Get Data From Aggregation60Answer query by getting data from aggregation. This event may have a negative impact on performance when turned on.
Get Data From Cache61Answer query by getting data from one of the caches. This event may have a negative impact on performance when turned on.
Query Cube Begin70Collects all Query Cube Begin events since the trace started.
Query Cube End71Collects all Query Cube End events since the trace started.
Calculate Non Empty Begin72Calculate non empty begin.
Calculate Non Empty Current73Calculate non empty current.
Calculate Non Empty End74Calculate non empty end.
Serialize Results Begin75Serialize results begin.
Serialize Results Current76Serialize results current.
Serialize Results End77Serialize results end.
Execute MDX Script Begin78Execute MDX script begin.
Execute MDX Script Current79Execute MDX script current.
Execute MDX Script End80Execute MDX script end.
Query Dimension81Query dimension.
VertiPaq SE Query Begin82VertiPaq SE query
VertiPaq SE Query End83VertiPaq SE query

For information about the columns associated with each of the Query Processing event classes, see Query Processing Events Data Columns.

Analysis Services Trace Events

Community Additions

ADD
Show: