SSAS Usage Totals

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.

SentryOne SSAS Usage Totals

Filter Pane

SentryOne Filter Pane

The Filter pane provides a series of filters and controls for specifying which records to display. The following are the available filters.

  • SQL Servers
  • Databases
  • Cubes
  • Measure Groups

Controls

SentryOne Refresh Icon

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.

SentryOne Show Top