Analysis Services Trace Events

Article
04/01/2012

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

Command Events Event Category

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

Lock Events Category

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.

Queries Events Category

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.

Security Audit Event Category

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.

Session Events Event Category

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.

Analysis Services Trace Events

See Also

Other Resources

Additional resources