Notification Events Data Columns
Notification events are events that are not directly caused by users of Microsoft SQL Server Analysis Services. For example, notifications occur because of users updating underlying tables for proactive caching.
The Notifications Events event category has the following event class:
- Notification class
The following table lists the data columns for the event class.
Notification Class—Data Columns
Data Column |
Description |
|---|---|
ConnectionID |
Contains the unique connection ID associated with the notification event. |
TextData |
Contains the text data associated with the notification event. |
ServerName |
Contains the name of the Analysis Services instance on which the notification event occurred. |
CurrentTime |
Contains the current time of the notification event. |
DatabaseName |
Contains the name of the database in which the notification event occurred. |
Duration |
Contains the approximation of time taken by the notification event. |
EndTime |
Contains the time at which the notification event ended. |
EventSubclass |
Contains the class of event within the notification event. Values are: 1- Proactive Caching Begin 2- Proactive Caching End 3- Flight Recorder Snapshot Begin 4- Server Config file update 5- Object changes |
IntegerData |
Contains the integer data associated with the notification event. When the EventSubclass column is 5, values are: 1 = Created 2 = Deleted 3 = Changed object's properties 4 = Changed properties of the object's children 6 = Children added 7 = Children deleted 8 = Object fully processed 9 = Object partially processed 10 = Object unprocessed 11 = Object fully optimized 12 = Object partially optimized 13 = Object not optimized |
NTCanonicalUserName |
Contains the Windows user name associated with the notification event. The user name is in canonical form. For example, engineering.microsoft.com/software/user. |
NTUserName |
Contains the Windows user name associated with the notification event. |
ObjectID |
Contains the object ID associated with the notification event. The object ID is returned as a string. |
ObjectName |
Contains the object name associated with the notification event. |
ObjectPath |
Contains the object path associated with the notification event. The path is returned as a comma-separated list of parents, starting with the object's parent. |
ObjectReference |
Contains the object reference for the progress report end event. The object reference is encoded as XML by all parents by using tags to describe the object. |
ObjectType |
Contains the object type associated with the notification event. |
RequestProperties |
Contains the XML for Analysis (XMLA) request properties associated with the notification event. |
SPID |
Contains the server process ID (SPID) that uniquely identifies the user session associated with the notification event. The SPID directly corresponds to the session GUID used by XMLA. |
StartTime |
Contains the specified time (if available) at which the notification event started. |
NTDomainName |
Contains the Windows domain account associated with the notification event. |
SessionID |
Contains the session ID associated with the notification event. |