Getting Peak Performance for SQL Server Analysis Services (SSAS)


Troubleshooting performance problems with SQL Server Analysis Services (SSAS) can be a frustrating exercise—unless you know how to find the root cause of the problem. In this web seminar, Steven Wright will review some of the most common SSAS performance killers as well as useful metrics to monitor in SSAS Tabular model, which is now the default installation option in SQL Server 2017.  

What You'll Learn: 

  • Basic differences between SSAS Multidimensional and SSAS Tabular models—and important metrics to monitor that are common to both
  • Key metrics to monitor in SSAS Tabular model that can affect performance, including VertiPaq memory usage and VertiPaq paging policy  
  • How to use BI Sentry—which now includes extended support for Tabular mode—to analyze MDX and DAX queries, compare Storage Engine and Formula Engine time per query, view internal VertiPaq cache matches and scans, and investigate other potential SSAS Tabular performance bottlenecks.

If you're using SSAS, you won't want to miss this SSAS performance troubleshooting session. Join Steven Wright to discover how to find and fix SSAS performance killers—fast.

Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

Steven Wright

Steven Wright

Senior Product Manager, SentryOne

Steve (@SQL_Steve) is the Senior Product Manager for BI and Analytics at SentryOne. He holds the Microsoft Professional Program Data Science Certificate among other professional certifications. Steve has been with SentryOne for over twelve years with over 17 years’ experience working with SQL Server. 

Steve shares tips and tidbits picked up over years of providing support and training to our customers. His blog often provides a common sense explanation of the in-depth information the SentryOne platform can provide, as well as some tips for further enhancing the vast feature set already provided out of the box.

Companies with the highest demands for database performance choose SentryOne