MDX and DAX query analysis, a capability available in SentryOne SQL Sentry, provides in-depth details about SQL Server Analysis Services (SSAS) queries so you can analyze the impact of MDX query performance in Multidimensional mode and DAX query performance in Tabular mode.
Are you becoming more dependent on the power of SSAS to provide critical business intelligence for your company—but frustrated when SSAS performance is slow?
You're not alone. When Microsoft introduced SQL Server Analysis Services (SSAS) in 2000, SSAS was specifically designed to support databases based on a multidimensional (OLAP-style) model. Over the years, SSAS has evolved and now also supports an entirely separate data model, SSAS Tabular, which in SQL Server 2017 has become the default installation model.
Customers need a monitoring solution that keeps up with SSAS innovations, provides full analysis support for MDX and DAX queries, and simplifies SSAS performance monitoring and analysis
For powerful SSAS performance monitoring, look no further than SentryOne SQL Sentry.
Multidimensional Expressions (MDX) is an industry-standard query and calculation language used to retrieve data from OLAP databases. MDX can also be used to query data in an SSAS tabular database as long as the database is not configured to run in DirectQuery mode.
SQL Sentry can highlight resource contentions on the server if your SSAS Storage Engine is creating and updating cubes with new data, or if the Storage Engine is recalculating and reorganizing existing data while also processing new MDX queries.
SQL Sentry's MDX-specific Performance Counters such as Total cells calculated and Total recomputes can help you better understand whether your MDX queries are optimized or not.
SQL Sentry also shows you whether MDX performance is impacted by SSAS server constraints such as CPU, memory, disk, or network resource limitations.
Similarly, SQL Sentry offers numerous performance analysis features for Data Analysis Expressions (DAX) queries. DAX is a formula language used to create custom calculations in SSAS tabular model projects.
SQL Sentry provides internal details for DAX (as well as MDX) on Tabular models. You can see SSAS Storage Engine vs. Formula Engine time per query; internal VertiPaq cache matches and scans, and quickly identify callbacks to the Formula Engine, allowing you to pinpoint your Tabular model query bottlenecks.
Read more independent SentryOne reviews on TrustRadius.