The SentryOne SSAS Usage Totals tab in SentryOne BI Sentry provides information that can be used to determine what responses to take based on activity levels. This information is divided into three different groups:
For SSAS Multidimensional instances, BI Sentry provides three tabs to help you analyze data usage.
The first tab, Attributes, consists of attribute combinations—such as date, postal code, country, and so on—in SSAS commands, along with information such as duration and the number of queries used in a particular attribute group.
You can expand each attribute group to see various queries along with pertinent information for each query, including its duration, CPU usage, Formula Engine time, Storage Engine time, and so on.
This information helps you find queries that might be good candidates for aggregations.
The Aggregations and Partitions tabs in BI Sentry provide, similar to the Attributes tab, information about their usage. You can use these two tabs to see if some aggregations and partitions are never being used.
Because aggregations can be expensive resource-wise, BI Sentry helps you decide if a particular one is necessary.