SSAS Performance Metrics

What are SSAS Performance Metrics?

The SSAS Performance Metrics displayed by the Performance Analysis Dashboard in SentryOne BI 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:

BI Sentry

 

Accelerating SSAS performance can be challenging

Improving 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.

SentryOne BI 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 

 

SentryOne BI 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.

SentryOne BI Sentry Performance Metrics

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

 

 

SSAS Storage

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

What You Can Do with SSAS Performance Metrics

  • BI 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!

“Fantastic tool for SSAS monitoring!”

—Alvaro Costa, Senior Database Analyst, White and Case LLP
 

Read more independent SentryOne reviews on TrustRadius.