SQL Sentry Portal SSAS Usage Totals

Multidimensional Instances

The SSAS Usage Totals tab provides information that can be used to determine what responses to take based on activity levels. 

For Multidimensional instances, the information is divided into three different groups:

Tab	Description
Attributes	Use the Attributes tab to view which attribute combinations are hit the most to determine if creating an aggregation would improve performance. Expand a command to see the different queries, and to display more detailed information for each query.
Aggregations	Use the Aggregations tab to view the aggregations that are being used. Expand an aggregation to see text data for the queries.
Partitions	Use the Partitions tab to view the partitions that are being read the most.

Note:  If there are aggregations and partitions that don't display in these tabs, it's possible they aren't being used.

Tabular Instances

For Tabular instances, the only tab that displays in SSAS Usage Totals is the Object Memory Usage tab. Use the Object Memory Usage tab to view the objects that are using the most memory in your instance. Expand objects to drill down and display more detailed information about the memory usage.