Achieving Peak SQL Server Analysis Services (SSAS) Performance

This whitepaper 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.

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 SQL Sentry—which includes support for Multidimensional and 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.

This whitepaper 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.

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 SQL Sentry—which includes support for Multidimensional and 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.

Download now!


Your e-mail address is used to communicate with you about your registration, related products and services, and offers from select vendors. Refer to our Privacy Policy for additional information.