Monitoring Traces (XMLA)
You can use the Subscribe command in XML for Analysis (XMLA) to monitor an existing trace defined on an instance of Microsoft SQL Server SQL Server Analysis Services. The Subscribe command returns the results of a trace as a rowset.
Specifying a Trace
The Object property of the Subscribe command must contain an object reference to either an SQL Server Analysis Services instance or a trace on an SQL Server Analysis Services instance. If the Object property is not specified, or a trace identifier is not specified in the Object property, the Subscribe command monitors the default session trace for the explicit session specified in the SOAP header for the command.
Returning Results
The Subscribe command returns a rowset containing the trace events captured by the specified trace. The Subscribe command returns trace results until the command is canceled by the Cancel command.
The rowset contains the columns listed in the following table.
| Column | Data type | Description |
|---|---|---|
| EventClass | Integer | The event class of the event received by the trace. |
| EventSubclass | Long integer | The event subclass of the event received by the trace. |
| CurrentTime | Datetime | The time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'. |
| StartTime | Datetime | The time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'. |
| EndTime | Datetime | The time at which the event ended, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'. This column is not populated for event classes that describe the start of a process or action. |
| Duration | Long integer | The amount of total time (in milliseconds) elapsed for the event. |
| CPUTime | Long integer | The amount of processor time (in milliseconds) elapsed for the event. |
| JobID | Long integer | The job identifier for the process. |
| SessionID | String | The identifier of the session for which the event occurred. |
| SessionType | String | The type of the session for which the event occurred. |
| ProgressTotal | Long integer | The total number or amount of progress reported by the event. |
| IntegerData | Long integer | Integer data associated with the event. The contents of this column depend on the event class and subclass of the event. |
| ObjectID | String | The identifier of the object for which the event occurred. |
| ObjectType | String | The type of the object specified in ObjectName. |
| ObjectName | String | The name of the object for which the event occurred. |
| ObjectPath | String | The hierarchical path of the object for which the event occurred. The path is represented as a comma-delimited string of object identifiers for the parents of the object specified in ObjectName. |
| ObjectReference | String | The XML representation of the object reference for the object specified in ObjectName. |
| NestLevel | Integer | The level of the transaction for which the event occurred. |
| NumSegments | Long integer | The number of data segments affected or accessed by the command for which the event occurred. |
| Severity | Integer | The severity level of an exception for the event. The column can contain one of the following values: 0: Success 1: Information 2: Warning 3: Error |
| Success | Boolean | Indicates whether a command succeeded or failed. |
| Error | Long integer | The error number of the event, if applicable. |
| ConnectionID | String | The identifier of the connection for which the event occurred. |
| DatabaseName | String | The name of the database for which the event occurred. |
| NTUserName | String | The Windows user name of the user associated with the event. |
| NTDomainName | String | The Windows domain of the user associated with the event. |
| ClientHostName | String | The name of the computer on which the client application is running. This column is populated with the values passed by the client application. |
| ClientProcessID | Long integer | The process identifier of the client application. |
| ApplicationName | String | The name of the client application that created the connection to the SQL Server Analysis Services instance. This column is populated with the values passed by the client application, rather than the displayed name of the program. |
| NTCanonicalUserName | String | The Windows canonical user name of the user associated with the event. |
| SPID | String | The server process ID (SPID) of the session for which the event occurred. The value of this column directly corresponds to the session ID specified in the SOAP header of the XMLA message for which the event occurred. |
| TextData | String | The text data associated with the event. The contents of this column depend on the event class and subclass of the event. |
| ServerName | String | The name of the SQL Server Analysis Services instance for which the event occurred. |
| RequestParameters | String | The parameters of the parameterized query or XMLA command for which the event occurred. |
| RequestProperties | String | The properties of the XMLA method for which the event occurred. |