Databases Reference
In-Depth Information
Figure 13-44
8. Assume you build aggregations using usage based optimization wiz-
ard. You would want to learn if the aggregations are being utilized.
Analysis Services provides events to help you identify if the aggrega-
tions are hit. Create a new Trace and switch to the Events Selection
tab. Check the box next to Show all events. Expand the events under
the event class Query Processing. You can see the various events
that are provided by Analysis Services as shown in
Figure 13-45
.
If you select the events under Query Processing and monitor the trace events
you will be able to obtain information such as if Non Empty code path is being
utilized, if MDX script is being evaluated, if data is retrieved from Aggrega-
tions or from existing cache. These events will help you identify more details
about the queries sent by the users as well as total duration. You can later
analyze the MDX queries, build usage based optimization for long running
queries or try to optimize the long run MDX queries. As an administrator you
definitely need to know a little bit about the internals of the server to fine tune
it. We believe the ability to trace Analysis Services through SQL Profiler will
help with that, so try it out.
Search WWH ::
Custom Search