Optimizing SQL Server Analysis Services (SSAS)
Dive into this five-part guide to learn time-saving tips for boosting SSAS performance.
Publish Date: 7/12/2023
Whitepaper
Troubleshooting performance problems with SQL Server Analysis Services (SSAS) can be a frustrating exercise. This insightful guide by Steven Wright, database sales engineering manager at SolarWinds, helps uncover the myriad forces that can conspire to degrade SSAS performance. In this five-part guide, Wright explains MOLAP SSAS architecture, examines MDX query performance, and offers timesaving tips for tracking trace events and troubleshooting SSAS bottlenecks. While the information in this whitepaper focuses on SSAS in Multidimensional mode (MOLAP), future editions will expand on differences found in SSAS Tabular mode.
