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 2005 Analysis Services (SSAS) 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. |