Databases Reference
In-Depth Information
the events that have been selected. To see all the events and event
columns supported by Analysis Services you can click on the check
boxes Show all events and Show all columns. Familiarize yourself
with the various events and click Run.
Figure 13-42
7. You will now be able to see the various event columns within Profiler.
To see certain processing operations events open the Adventure
Works DW sample project and deploy it to the Analysis Services in-
stance. You can see the various events during the processing includ-
ing the processing duration of each object as shown in
Figure 13-43
.
This will help you to identify information such as dimension process-
ing duration, duration of processing partitions, as well as overall pro-
cessing time of the entire database. You can also see the relational
queries sent to data source to retrieve data during processing for
each object.
Search WWH ::
Custom Search