SQL Server Analysis Services (SSAS) Performance Monitoring

Free Trial Request Quote

As of April 2020, SQL Server Analysis Services (SSAS) performance monitoring will be available as part of SQL Sentry Standard and Premium. BI Sentry will no longer be available for purchase. You will have the option to use a SQL Sentry Standard or Premium license to monitor an SSAS instance.

Quickly find and fix SSAS performance problems with SQL Sentry

SQL Sentry empowers you to monitor, diagnose, and optimize 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, as well as 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 that you can identify and address common SSAS performance problems.

  • Unique insight into VertiPaq memory limits and paging policy 

  • Top Commands view that helps you identify bottlenecks for both DAX and MDX queries

  • Object Memory Usage tab that helps you optimize in-memory compression of your data model   

 

SQL Sentry provides actionable information so that you can proactively address SSAS performance bottlenecks

 

The SQL Sentry performance dashboard shows both Windows- and SSAS-specific metrics side by side for a complete view of data platform performance. Learn more about the extended support for SSAS Tabular in SQL Sentry. 

SQL Sentry gives you a complete view of SSAS performance so that you can identify and address problems that have widespread impact across your data estate.

Unleash SSAS performance with these powerful capabilities

 

SSAS Top Commands

See the total impact of your MDX, DAX, or XMLA Commands

The SQL Sentry Top Commands tab shows SSAS query-level collection and any MDX, DAX, or XMLA commands that have run longer than one second. All the like queries have been rolled up and grouped together so you can see their total impact.

Learn More

SSAS Usage Totals

Use relevant metrics to troubleshoot SSAS problems

The SQL Sentry SSAS Usage Totals tab provides information that can be used to determine what responses to take based on activity levels. This information is divided into three different groups:

  • Attributes—used to see which attribute combinations are hit the most to determine if creating an aggregation would improve performance

  • Aggregations—shows the aggregations that are being used

  • Partitions—shows which partitions are being read the most

Learn More

SentryOne BI Sentry Performance Metrics Compressed

SSAS Performance Metrics

Accelerate SSAS performance with detailed, relevant 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. Learn more.

 

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.

Download Free Trial

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.

Schedule Demo

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.

Learn More