Analysis Services Trace Events
You can follow the activity of a Microsoft SQL Server Analysis Services (SSAS) 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 using SQL Server Profiler, see Use SQL Server Profiler to Monitor Analysis Services, or can be started from an XMLA command as SQL Server Extended Events and later analyzed, see Use SQL Server Extended Events (XEvents) to Monitor Analysis Services.
The following table lists all event categories for Analysis Services with a brief description of the category. From each item in the list you can link to all events in that category and their descriptions; detailed information is available following the title link of each category.
Event Category |
Description |
|---|---|
Command Events |
Collection of events for commands. |
Discover Events |
Collection of events for discover requests. |
Discover Server State Events |
Collection of events for server state discovers. |
Errors and Warnings |
Collection of events for server errors. |
File Load and Save |
Collection of events for file load and save operations reporting. |
Locks |
Collection of lock related events. |
Notification Events |
Collection of notification events. |
Progress Reports |
Collection of events for progress reporting. |
Queries Events |
Collection of events for queries. |
Query Processing |
Collection of key events during the process of a query execution. |
Security Audit |
Collection of database audit event classes. |
Session Events |
Collection of session 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 Analysis Services 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 |
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. |