Query Processing Events Data Columns

  • Article

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

Event ID

Event Name

Event Description

70

Query Cube Begin

Query cube begin.

71

Query Cube End

Query cube end.

72

Calculate Non Empty Begin

Calculate non empty begin.

73

Calculate Non Empty Current

Calculate non empty current.

74

Calculate Non Empty End

Calculate non empty end.

75

Serialize Results Begin

Serialize results begin.

76

Serialize Results Current

Serialize results current.

77

Serialize Results End

Serialize results end.

78

Execute MDX Script Begin

Execute MDX script begin.

79

Execute MDX Script Current

Execute MDX script current. Deprecated.

80

Execute MDX Script End

Execute MDX script end.

81

Query Dimension

Query dimension.

11

Query Subcube

Query subcube, for Usage Based Optimization.

12

Query Subcube Verbose

Query subcube with detailed information. This event may have a negative impact on performance when turned on.

60

Get Data From Aggregation

Answer query by getting data from aggregation. This event may have a negative impact on performance when turned on.

61

Get Data From Cache

Answer query by getting data from one of the caches. This event may have a negative impact on performance when turned on.

82

VertiPaq SE Query Begin

VertiPaq SE query

83

VertiPaq SE Query End

VertiPaq SE query

84

Resource Usage

Reports reads, writes, cpu usage after end of commands and queries.

85

VertiPaq SE Query Cache Match

VertiPaq SE query cache use

98

Direct Query Begin

Direct Query Begin.

99

Direct Query End

Direct Query End.

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

Query Cube Begin

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Query Cube End

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Calculate Non Empty Begin

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Calculate Non Empty Current

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

1

Get Data

2

Process Calculated Members

3

Post Order

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Calculate Non Empty End

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Serialize Results Begin

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Serialize Results Current

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

1

Serialize Axes

2

Serialize Cells

3

Serialize SQL Rowset

4

Serialize Flattened Rowset

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Serialize Results End

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Execute MDX Script Begin

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

1

MDX Script

2

MDX Script Command

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Execute MDX Script Current

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Execute MDX Script End

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

1

MDX Script

2

MDX Script Command

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Query Dimension

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

1

Cache data

2

Non-cache data

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectType

12

1

Object type.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Query Subcube

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

1

Cache data

2

Non-cache data

3

Internal data

4

SQL data

11

Measure Group Structural Change

12

Measure Group Deletion

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Query Subcube Verbose

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

21

Cache data

22

Non-cache data

23

Internal data

24

SQL data

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Get Data From Aggregation

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Get Data From Cache

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

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

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

VertiPaq SE Query Begin

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

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

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

JobID

7

1

Job ID for progress.

SessionType

8

8

Session type (what entity caused the operation).

ObjectID

11

8

Object ID (note this is a string).

ObjectType

12

1

Object type.

ObjectName

13

8

Object name.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ObjectReference

15

8

Object reference. Encoded as XML for all parents, using tags to describe the object.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTUserName

32

8

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

VertiPaq SE Query End

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

0

VertiPaq Scan

1

Tabular Query

10

VertiPaq Scan internal

11

Tabular Query internal

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

JobID

7

1

Job ID for progress.

SessionType

8

8

Session type (what entity caused the operation).

ProgressTotal

9

1

Progress total.

IntegerData

10

1

Integer data.

ObjectID

11

8

Object ID (note this is a string).

ObjectType

12

1

Object type.

ObjectName

13

8

Object name.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ObjectReference

15

8

Object reference. Encoded as XML for all parents, using tags to describe the object.

Severity

22

1

Severity level of an exception.

Success

23

1

1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).

Error

24

1

Error number of a given event.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTUserName

32

8

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Resource Usage

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTUserName

32

8

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

ClientProcessID

36

1

The process ID of the client application.

ApplicationName

37

8

Name 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.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

VertiPaq SE Query Cache Match

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

0

VertiPaq Cache exact match

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

JobID

7

1

Job ID for progress.

SessionType

8

8

Session type (what entity caused the operation).

ObjectID

11

8

Object ID (note this is a string).

ObjectType

12

1

Object type.

ObjectName

13

8

Object name.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

ObjectReference

15

8

Object reference. Encoded as XML for all parents, using tags to describe the object.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTUserName

32

8

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Direct Query Begin

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

JobID

7

1

Job ID for progress.

SessionType

8

8

Session type (what entity caused the operation).

IntegerData

10

1

Integer data.

ObjectID

11

8

Object ID (note this is a string).

ObjectType

12

1

Object type.

ObjectName

13

8

Object name.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

Severity

22

1

Severity level of an exception.

Success

23

1

1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).

Error

24

1

Error number of a given event.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

ClientProcessID

36

1

The process ID of the client application.

SessionID

39

8

Session GUID.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

Direct Query End

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Time 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'.

Duration

5

2

Amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Amount of CPU time (in milliseconds) used by the event.

JobID

7

1

Job ID for progress.

SessionType

8

8

Session type (what entity caused the operation).

IntegerData

10

1

Integer data.

ObjectID

11

8

Object ID (note this is a string).

ObjectType

12

1

Object type.

ObjectName

13

8

Object name.

ObjectPath

14

8

Object path. A comma-separated list of parents, starting with the object's parent.

Severity

22

1

Severity level of an exception.

Success

23

1

1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).

Error

24

1

Error number of a given event.

ConnectionID

25

1

Unique connection ID.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

ClientProcessID

36

1

The process ID of the client application.

SessionID

39

8

Session GUID.

SPID

41

1

Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.

TextData

42

9

Text data associated with the event.

ServerName

43

8

Name of the server producing the event.

See Also

Concepts

Query Processing Events Category