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