SQL Server Analysis Services Performance Monitoring

Quickly find and fix SQL Server Analysis Services (SSAS) performance problems

SQL Sentry provides actionable information so you can 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.

  • Unique insight into VertiPaq memory limits and paging policy 
  • Top Commands view designed to help you identify bottlenecks for DAX and MDX queries
  • Object Memory Usage tab designed to help you optimize in-memory compression of your data model

SSAS Top Commands

SSAS Top 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 are rolled up and grouped together so you can see their total impact.

SSAS Usage Totals

SSAS Usage Totals

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

  1. Attributes: used to see which attribute combinations are hit the most to determine whether creating an aggregation would improve performance

  2. Aggregations: shows the aggregations being used

  3. Partitions: shows which partitions are being read the most
 

SSAS Performance Metrics

SSAS Performance Metrics

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.

Get started with SQL Server Analysis Services (SSAS) performance monitoring

SolarWinds SQL Sentry

  • 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.
{#Contact Phone#}
Close
{{STATIC CONTENT}}
{{CAPTION_TITLE}}

{{CAPTION_CONTENT}}

{{TITLE}}