Analysis Services Trace Events
Applies to: 
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
You can follow the activity of an instance by capturing and then analyzing the trace events generated by the instance. Trace events are grouped so that you can more easily find related trace events. Each trace event contains a set of data relevant to the event; not all pieces of data are relevant to all events.
Trace events can be started and captured by using SQL Server Profiler or started from an XMLA command as SQL Server Extended Events. To learn more, see Monitor Analysis Services with SQL Server Extended Events.
The following tables describe each event category and the events in that category. Each table contains the following columns:
Event Id
An integer value that identifies the event type. This value is useful whenever you are reading traces converted to tables or XML files to filter the event type.
Event Name
The name given to the event in client applications.
Event Description
A brief description of the event
Collection of events for commands.
| Event Id | Event Name | Event Description |
|---|---|---|
| 15 | Command Begin | Command begin. |
| 16 | Command End | Command end. |
Discover Events Event Category
Collection of events for discover requests.
| Event Id | Event Name | Event Description |
|---|---|---|
| 36 | Discover Begin | Start of Discover Request. |
| 38 | Discover End | End of Discover Request. |
Discover Server State Event Category
Collection of events for server state discovers.
| Event Id | Event Name | Event Description |
|---|---|---|
| 33 | Server State Discover Begin | Start of Server State Discover. |
| 34 | Server State Discover Data | Contents of the Server State Discover Response. |
| 35 | Server State Discover End | End of Server State Discover. |
Errors and Warnings Event Category
Collection of events for server errors.
| Event Id | Event Name | Event Description |
|---|---|---|
| 17 | Error | Server error. |
File Load and Save Event Category
Collection of events for file load and save operations reporting.
| Event Id | Event Name | Event Description |
|---|---|---|
| 90 | File Load Begin | File Load Begin. |
| 91 | File Load End | File Load End. |
| 92 | File Save Begin | File Save Begin. |
| 93 | File Save End | File Save End |
| 94 | PageOut Begin | PageOut Begin. |
| 95 | PageOut End | PageOut End |
| 96 | PageIn Begin | PageIn Begin. |
| 97 | PageIn End | PageIn End |
Job Graph Events Event Category
Collection of events related to database processing job dependencies.
| Event Id | Event Name | Event Description |
|---|---|---|
| 134 | Job Graph | Collection of Job Graph related events. |
Collection of lock related events.
| Event Id | Event Name | Event Description |
|---|---|---|
| 50 | Deadlock | Metadata locks deadlock. |
| 51 | Lock Timeout | Metadata lock timeout. |
| 52 | Lock Acquired | Lock Acquired |
| 53 | Lock Released | Lock Released |
| 54 | Lock Waiting | Lock Waiting |
Notification Events Event Category
Collection of notification events.
| Event Id | Event Name | Event Description |
|---|---|---|
| 39 | Notification | Notification event. |
| 40 | User Defined | User defined Event. |
Progress Reports Event Category
Collection of events for progress reporting.
| Event Id | Event Name | Event Description |
|---|---|---|
| 5 | Progress Report Begin | Progress report begins. |
| 6 | Progress Report End | Progress report end. |
| 7 | Progress Report Current | Progress report current. |
| 8 | Progress Report Error | Progress report error. |
Collection of events for queries.
| Event Id | Event Name | Event Description |
|---|---|---|
| 9 | Query Begin | Query begins. |
| 10 | Query End | Query end. |
Query Processing Events Category
Collection of key events during the process of a query execution.
| Event Id | Event Name | Event Description |
|---|---|---|
| 70 | Query Cube Begin | Query cube begin. |
| 71 | Query Cube End | Query cube end. |
| 72 | Calculate Non Empty Begin | Calculate non empty begin. |
| 73 | Calculate Non Empty Current | Calculate non empty current. |
| 74 | Calculate Non Empty End | Calculate non empty end. |
| 75 | Serialize Results Begin | Serialize results begin. |
| 76 | Serialize Results Current | Serialize results current. |
| 77 | Serialize Results End | Serialize results end. |
| 78 | Execute MDX Script Begin | Execute MDX script begin. |
| 79 | Execute MDX Script Current | Execute MDX script current. Deprecated. |
| 80 | Execute MDX Script End | Execute MDX script end. |
| 81 | Query Dimension | Query dimension. |
| 11 | Query Subcube | Query subcube, for Usage Based Optimization. |
| 12 | Query Subcube Verbose | Query subcube with detailed information. This event may have a negative impact on performance when turned on. |
| 60 | Get Data From Aggregation | Answer query by getting data from aggregation. This event may have a negative impact on performance when turned on. |
| 61 | Get Data From Cache | Answer query by getting data from one of the caches. This event may have a negative impact on performance when turned on. |
| 82 | VertiPaq SE Query Begin | VertiPaq SE query |
| 83 | VertiPaq SE Query End | VertiPaq SE query |
| 84 | Resource Usage | Reports reads, writes, cpu usage after end of commands and queries. |
| 85 | VertiPaq SE Query Cache Match | VertiPaq SE query cache use |
| 98 | Direct Query Begin | Direct Query Begin. |
| 99 | Direct Query End | Direct Query End. |
Collection of database audit event classes.
| Event Id | Event Name | Event Description |
|---|---|---|
| 1 | Audit Login | Collects all new connection events since the trace was started, such as when a client requests a connection to a server running an instance of SQL Server. |
| 2 | Audit Logout | Collects all new disconnect events since the trace was started, such as when a client issues a disconnect command. |
| 4 | Audit Server Starts And Stops | Records service shut down, start, and pause activities. |
| 18 | Audit Object Permission Event | Records object permission changes. |
| 19 | Audit Admin Operations Event | Records server backup/restore/synchronize/attach/detach/imageload/imagesave. |
Collection of session events.
| Event Id | Event Name | Event Description |
|---|---|---|
| 41 | Existing Connection | Existing user connection. |
| 42 | Existing Session | Existing session. |
| 43 | Session Initialize | Session Initialize. |