The SSAS Usage Totals tab provides information that can be used to determine what responses to take based on activity levels. The information is divided into three different groups:
- Attributes—Used to see which attribute combinations are hit the most to determine if creating an aggregation would improve performance.
- Aggregations—Shows the aggregations that are being used.
- Partitions—Shows which partitions are being read the most.
The Filter pane provides a series of filters and controls for specifying which records to display. The following are the available filters.
- SQL Servers
- Measure Groups
After changing any of the filters, select the Refresh icon or press F5 to apply the filter. Select a combination of items in any of the lists to set the filters. The default filter is to display all records. Use shift-click or ctrl-click to select more than one item in a list. Depending on the length of the displayed interval, you may have a lot of data to work with. The Show Top setting controls how many of the rows are actually retrieved.