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.
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.
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.
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.
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.
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.
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.
The SSAS Storage section provides information that can help you determine whether the disk system is a bottleneck for your SSAS instance.
The SQL Sentry Performance Analysis Dashboard displays actionable SSAS performance metrics that you can use to accelerate performance of SSAS.