Sdílet prostřednictvím


Queries Events Data Columns

The Queries Events event category has the following event classes:

  • Query Begin class

  • Query End class

  • Query Subcube class

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

Query Begin Class—Data Columns

Data Column

Description

ConnectionID

Contains the unique connection ID associated with the query event.

TextData

Contains the text data associated with the query event.

ServerName

Contains the name of the instance of Microsoft SQL Server Analysis Services on which the query event occurred.

CurrentTime

Contains the current time of the query event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the query is running.

EventSubclass

Contains the class of event within the query begin event. Values are:

0 = Multidimensional Expressions (MDX) Query

1 = Data Mining Extensions (DMX) Query

2 = SQL Query

NTCanonicalUserName

Contains the Windows user name associated with the query event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

NTUserName

Contains the Windows user name associated with the query event.

RequestProperties

Contains the XML for Analysis (XMLA) request properties associated with the query event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the query event. The SPID directly corresponds to the session GUID used by XMLA.

StartTime

Contains the time (if available) at which the query started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

RequestParameters

Contains the parameters for parameterized queries associated with the query event.

NTDomainName

Contains the Windows domain account associated with the query event.

ApplicationName

Contains the name of the client application that created the connection to the server.

ClientProcessID

Contains the process ID of the client application.

Query End Class—Data Columns

Data Column

Description

ConnectionID

Contains the unique connection ID associated with the query event.

TextData

Contains the text data associated with the query event.

ServerName

Contains the name of the instance of Analysis Services on which the query event occurred.

CurrentTime

Contains the current time of the query event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the query is running.

Duration

Contains the length of time between the query begin event and the query end event.

EndTime

Contains the time at which the query end event occurred. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

EventSubclass

Contains the class of event within the query begin event. Values are:

0 = Multidimensional Expressions (MDX) Query

1 = Data Mining Extensions (DMX) Query

2 = SQL Query

NTCanonicalUserName

Contains the Windows user name associated with the query event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

NTUserName

Contains the Windows user name associated with the query event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the query event. The SPID directly corresponds to the session GUID used by XMLA.

StartTime

Contains the time (if available) at which the query started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

CPUTime

Contains the amount of CPU time (in milliseconds) used by the process between the time of the query begin event and the query end event.

Error

Contains the error number of any error associated with the query event.

Severity

Contains the severity level of an exception associated with the query event. Values are:

0 = Success

1 = Informational

2 = Warning

3 = Error

Success

Contains the success or failure of the query event. Values are:

0 = Failure

1 = Success

NTDomainName

Contains the Windows domain account associated with the query event.

Query Subcube Class—Data Columns

Data Column

Description

ConnectionID

Contains the unique connection ID associated with the query subcube event.

TextData

Contains the text data associated with the query subcube event.

ServerName

Contains the name of the instance of Analysis Services on which the query subcube event occurred.

CurrentTime

Contains the current time of the query subcube event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the query subcube event occurred.

Duration

Contains the approximate amount of time taken by the query subcube event.

EndTime

Contains the time at which the query subcube event ended. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

EventSubclass

Contains the class of event within the query subcube event. Values are:

1 = From cache

2 = Not from cache

3 = internal

4 = SQL

SPID

Contains the server process ID (SPID) that uniquely identifies the user session query subcube event. The SPID directly corresponds to the session GUID used by XMLA.

StartTime

Contains the time (if available) at which the query subcube event started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

CPUTime

Contains the amount of CPU time (in milliseconds) used by the subcube query event.

SessionID

Contains the session ID associated with the object permission event.

See Also

Other Resources