SSAS Usage Totals
Attributes
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.
Aggregations and Partitions tabs
Similar to the Attributes tab, the Aggregations and Partitions tabs in SQL Sentry provide 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, SQL Sentry helps you decide if a particular one is necessary.
Object Memory Usage
Cardinality
Another piece of information you need to successfully troubleshoot SSAS performance is the cardinality of your data. Cardinality refers to the number of unique values. The SSAS VertiPaq columnar storage can realize up to 10x data compression.
However, this rate depends on your data’s cardinality. Data with low cardinality (such as gender) will see the best compression. Data with high cardinality (such as invoice number) will see the worst compression.
Need Deeper Usage Insights into Your SSAS Instance?
What is SSAS Usage Totals?
The SSAS Usage Totals tab provides information you can use to determine what responses to take based on activity levels. This information is divided into three different groups: Attributes, Aggregations, and Partitions.
Does SSAS Usage Totals support both Multidimensional and Tabular modes?
SSAS Usage Totals supports Multidimensional and Tabular modes and provides mode-specific information on the data in use. In SSAS Multidimensional mode, SSAS Usage Totals helps you identify potential “pre-aggregating” sets of data to improve query performance and calculation times. In Tabular mode, SSAS Usage Totals surfaces essential memory usage details and tracks memory usage over time.
How do I get detailed information on the data in my SSAS Multidimensional or Tabular instance?
If you're struggling to troubleshoot SSAS performance problems with insufficient information, consider SQL Sentry—get the visibility you need to create and maintain a high-performance SSAS environment.
- What is SSAS Usage Totals?
- Does SSAS Usage Totals support both Multidimensional and Tabular modes?
- How do I get detailed information on the data in my SSAS Multidimensional or Tabular instance?
What is SSAS Usage Totals?
The SSAS Usage Totals tab provides information you can use to determine what responses to take based on activity levels. This information is divided into three different groups: Attributes, Aggregations, and Partitions.
Get started with SQL Server Analysis Services (SSAS) performance monitoring
SolarWinds SQL Sentry
Fast root cause analysis
Visibility across the data estate
Deep, actionable performance metrics with easy deep-dive capabilities
