SSAS Performance Monitoring Tool
Quickly find and fix SQL Server Analysis Services (SSAS) performance problems
Proactively address SSAS performance bottlenecks
SQL Sentry® empowers you to monitor, diagnose, and optimize the SQL Server Analysis Services (SSAS) Multidimensional and Tabular modes. With SQL Sentry, you gain unparalleled insight into SSAS performance issues, including bottlenecks related to memory and storage systems, aggregation usage, unoptimized queries, and query and processing tasks competing for the same resources.
SQL Sentry includes enhanced support for SSAS Tabular mode and continued support for Multidimensional mode so you can identify and address common SSAS performance problems.
Streamline and optimize SSAS performance tuning with clear, relevant table model SSAS tuning metrics
SQL Server Analysis Services (SSAS) performance tuning is notoriously difficult because it’s challenging to gather relevant metrics all in one place. The information needed to find a root cause could be anywhere, and you don’t necessarily have the time to search for it. SolarWinds® SQL Sentry offers a performance analysis dashboard including SSAS Activity, SSAS General, SSAS Memory, and SSAS Storage—four key metrics impacting SSAS table query performance. Now, you can take a quicker and more targeted approach to SSAS performance tuning.
Use SSAS Top Commands to understand the total impact of SSAS performance and operations tuning
To dig deeper into SSAS performance and operations tuning, you need to break down SSAS performance issues with user hierarchies by time and see how specific events affected performance. SQL Sentry captures all MDX, DAX, DMX, and XMLA commands, and you can set time-based thresholds for collecting them. By viewing runtime stats for each command and investigating queries at a granular level, you can see which statements affect SSAS table query performance the most and address them quickly.
Troubleshoot SSAS performance issues with user hierarchies more effectively with SSAS Usage Totals
In high-performance SSAS environments, having set remediation actions at the ready is critical. SQL Sentry SSAS Usage Totals offer the deeper data usage insights you need to troubleshoot rapidly. “Attributes” shows which attribute combinations hit most often, “Aggregations” shows which aggregations are being used, and “Partitions” shows which partitions are read the most. These three groups will help you determine what responses must be taken based on activity levels, which speeds up troubleshooting.
Unlock more actionable data with extended support for performance tuning on SSAS tabular
As more DBAs start monitoring SSAS in Tabular mode, performance tuning on SSAS tabular becomes essential. SQL Sentry now features enhanced support for SSAS in Tabular mode. New Tabular mode-exclusive metrics have been added to the performance dashboard, SQL Sentry now features enhanced DAX query analysis, and the SSAS Usage Totals now include Object Memory Usage. These features will help you take table model SSAS tuning to the next level.
Get More on SSAS Performance Monitoring
Frequently asked questions
The SSAS Performance Metrics displayed by the Performance Analysis Dashboard in SQL Sentry give you valuable insight into the root cause of performance problems with SSAS. With actionable information, you can save time in troubleshooting SSAS performance.
SSAS Activity
The SSAS Activity section displays information to help 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 using the memory allocated to it. When monitoring a Tabular instance, you can see the memory counters and the VertiPaq memory limit. This data helps you understand where physical memory usage might cause performance issues.
SSAS Storage
The SSAS Storage section provides information to help you determine whether the disk system is a bottleneck for your SSAS instance.
Get started with SQL Server Analysis Services (SSAS) performance monitoring
- Fast root cause analysis
- Visibility across the data estate
- Deep, actionable performance metrics with easy deep-dive capabilities
Let’s talk it over.
Contact our team. Anytime.