Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |