Skip to content

Optimizing memory settings in Analysis Services

'When you manage instances of SQL Server Analysis Services (SSAS) or Azure Analysis Services, you can modify the instance’s memory settings. The default settings are usually right for generic configurations; that said, you might want to consider alternative settings to optimize a heavier workload, dedicated machines, or to solve memory errors in particular conditions. The goal of the article is to provide practical tips to optimize the memory settings for specific scenarios. Unless otherwise specified, the settings apply to all the versions of Analysis Services (AS).'

https://www.sqlbi.com/articles/optimizing-memory-settings-in-analysis-services/#