SSAS Performance Metrics

What are SSAS performance metrics?

The SSAS performance metrics displayed by the Performance Analysis Dashboard in SentryOne SQL Sentry give you valuable insight into the root cause of performance problems with SQL Server Analysis Services (SSAS). With actionable information, you can save time in troubleshooting SSAS performance.

You'll find this feature in:

SQL Sentry

Download Free Trial

Accelerating SSAS performance can be challenging

Improving the performance of SQL Server Analysis Services (SSAS) is notoriously difficult because it's not easy to collect the performance metrics you need to troubleshoot problems.

To get to the root cause of performance problems with SSAS, you need accurate information.

Are the MDX or DAX queries performing poorly?
Do you have details about the SSAS Storage Engine processing performance?
Does your server have memory or other server resource constraints?

The cause of SSAS performance problems could be lurking in any number of places. To successfully troubleshoot SSAS performance, you need a baseline understanding of the SSAS architecture and the inner workings of SSAS in Multidimensional and Tabular modes.

You also need the right monitoring tool—one that can give you deep insights into the performance metrics that help you analyze your SSAS environment in real time and during a specified period in the past.

SQL Sentry is the one monitoring solution on the market that gives you the detailed metrics you need to monitor, diagnose, and optimize the performance of your SSAS environment.

Accelerate SSAS performance with detailed, relevant metrics

SQL Sentry adjusts the performance metrics display in the Performance Analysis Dashboard based on whether you're monitoring a Tabular or a Multidimensional SSAS instance. The Dashboard includes four sections for SSAS performance metrics.

SSAS Activity

The SSAS Activity section displays information that helps you correlate the rate of rows sent by the server to the clients with the number of threads used by the SSAS Formula and Storage Engines.

SSAS General

The SSAS General section displays information about the activity taking place on your monitored server instance, including average time, which shows what the SSAS instance is spending most of its time doing. The General section also displays activity such as the number of MDX cell calculations, which can help you pinpoint issues with either the SSAS Formula or Storage Engine.

SSAS Memory

The SSAS Memory section gives you details about how the server instance is utilizing the memory that has been allocated to it. When monitoring a Tabular instance, you can see the memory counters and the VertPaq memory limit. This data helps you understand where physical memory usage might cause performance issues.

SSAS Storage

The SSAS Storage section provides information that can help you determine whether the disk system is a bottleneck for your SSAS instance.

SentryOne SQL Sentry Performance Metrics

The SQL Sentry Performance Analysis Dashboard displays actionable SSAS performance metrics that you can use to accelerate performance of SSAS.

What You Can Do with SSAS Performance Metrics

The SQL Sentry Performance Analysis Dashboard displays relevant metrics specific to your SSAS environment
Metrics are organized in sections and include detailed Activity, General, Memory, and Storage metrics
Provides full support for Tabular and Multidimensional modes
And more!

More about SSAS performance metrics

More resources

Ready to end your database performance problems?

Download a SQL Sentry trial

See for yourself how SQL Sentry can help you achieve optimal database performance.

Schedule a SQL Sentry demo

Learn more about how SQL Sentry can help you troubleshoot and prevent database performance problems. Register to attend a public demo or schedule a one-on-one session.

Learn more about SQL Sentry

Discover how you can quickly find and fix SQL Server performance problems with SQL Sentry, which delivers proven scalability, easy-access dashboards, and visibility across your entire database environment.