Analysis Services Event Classes
In SQL Server Profiler, you can use event categories to monitor events in Microsoft SQL Server 2005 Analysis Services (SSAS). Event categories contain event classes that are grouped together within the SQL Server Profiler user interface. These event classes describe each action (event) in Analysis Services. For example, a statement about to be executed against Analysis Services initiates an event with the StatementBefore event class.
An event class may have event subclasses that describe finer levels of categorization. For example, the AggregationAfter event class has two event subclasses: Lazy and Regular. Each event subclass also has several columns associated with that class. The columns describing a trace event are consistent for all events; however, the information recorded in each column may differ depending on the event class. For example, the TextData column records the original DDL for all statement events, but there is no DDL for aggregation events.
You can use some or all trace columns, and select one or more event classes to be traced at the same time. Additionally, you can use filter criteria to selectively trace event classes. For example, you can trace only those events that change a specific cube or only the StatementBefore event class.
Note
SQL Server Profiler generates trace events for only those events to which the profiler is listening.
The following table describes the SQL Server Profiler event categories for Analysis Services and their associated event classes.
| Event category | Description |
|---|---|
Collection of database audit event classes. |
|
Collection of events for progress reporting. |
|
Collection of events for queries. |
|
Collection of events for commands. |
|
Collection of error events. |
|
Collection of events for server state discover requests. |
|
Collection of events for discover requests. |
|
Collection of notification events. |
|
Collection of session events. |
See Also
Other Resources
Using SQL Server Profiler to Monitor Analysis Services