Trace Events

Analysis Services Trace Events

 

Applies To: SQL Server 2016

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 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 Analysis Services client applications.

Event Description
A brief description of the event

Command Events Event Category

Collection of events for commands.

Event IdEvent NameEvent Description
15Command BeginCommand begin.
16Command EndCommand end.

Discover Events Event Category

Collection of events for discover requests.

Event IdEvent NameEvent Description
36Discover BeginStart of Discover Request.
38Discover EndEnd of Discover Request.

Discover Server State Event Category

Collection of events for server state discovers.

Event IdEvent NameEvent Description
33Server State Discover BeginStart of Server State Discover.
34Server State Discover DataContents of the Server State Discover Response.
35Server State Discover EndEnd of Server State Discover.

Errors and Warnings Event Category

Collection of events for server errors.

Event IdEvent NameEvent Description
17ErrorServer error.

File Load and Save Event Category

Collection of events for file load and save operations reporting.

Event IdEvent NameEvent Description
90File Load BeginFile Load Begin.
91File Load EndFile Load End.
92File Save BeginFile Save Begin.
93File Save EndFile Save End
94PageOut BeginPageOut Begin.
95PageOut EndPageOut End
96PageIn BeginPageIn Begin.
97PageIn EndPageIn End

Lock Events Category

Collection of lock related events.

Event IdEvent NameEvent Description
50DeadlockMetadata locks deadlock.
51Lock TimeoutMetadata lock timeout.
52Lock AcquiredLock Acquired
53Lock ReleasedLock Released
54Lock WaitingLock Waiting

Notification Events Event Category

Collection of notification events.

Event IdEvent NameEvent Description
39NotificationNotification event.
40User DefinedUser defined Event.

Progress Reports Event Category

Collection of events for progress reporting.

Event IdEvent NameEvent Description
5Progress Report BeginProgress report begins.
6Progress Report EndProgress report end.
7Progress Report CurrentProgress report current.
8Progress Report ErrorProgress report error.

Queries Events Category

Collection of events for queries.

Event IdEvent NameEvent Description
9Query BeginQuery begins.
10Query EndQuery end.

Query Processing Events Category

Collection of key events during the process of a query execution.

Event IdEvent NameEvent Description
70Query Cube BeginQuery cube begin.
71Query Cube EndQuery cube end.
72Calculate Non Empty BeginCalculate non empty begin.
73Calculate Non Empty CurrentCalculate non empty current.
74Calculate Non Empty EndCalculate non empty end.
75Serialize Results BeginSerialize results begin.
76Serialize Results CurrentSerialize results current.
77Serialize Results EndSerialize results end.
78Execute MDX Script BeginExecute MDX script begin.
79Execute MDX Script CurrentExecute MDX script current. Deprecated.
80Execute MDX Script EndExecute MDX script end.
81Query DimensionQuery dimension.
11Query SubcubeQuery subcube, for Usage Based Optimization.
12Query Subcube VerboseQuery subcube with detailed information. This event may have a negative impact on performance when turned on.
60Get Data From AggregationAnswer query by getting data from aggregation. This event may have a negative impact on performance when turned on.
61Get Data From CacheAnswer query by getting data from one of the caches. This event may have a negative impact on performance when turned on.
82VertiPaq SE Query BeginVertiPaq SE query
83VertiPaq SE Query EndVertiPaq SE query
84Resource UsageReports reads, writes, cpu usage after end of commands and queries.
85VertiPaq SE Query Cache MatchVertiPaq SE query cache use
98Direct Query BeginDirect Query Begin.
99Direct Query EndDirect Query End.

Security Audit Event Category

Collection of database audit event classes.

Event IdEvent NameEvent Description
1Audit LoginCollects 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.
2Audit LogoutCollects all new disconnect events since the trace was started, such as when a client issues a disconnect command.
4Audit Server Starts And StopsRecords service shut down, start, and pause activities.
18Audit Object Permission EventRecords object permission changes.
19Audit Admin Operations EventRecords server backup/restore/synchronize/attach/detach/imageload/imagesave.

Session Events Event Category

Collection of session events.

Event IdEvent NameEvent Description
41Existing ConnectionExisting user connection.
42Existing SessionExisting session.
43Session InitializeSession Initialize.

Use SQL Server Profiler to Monitor Analysis Services

Community Additions

ADD
Show:
© 2016 Microsoft