Severe Memory Pressure on SSAS 2008 on Windows Server 2008
I have a single instance of SQL Server 2008 Analysis Services running on Windows Server 2008 x64 with 8GB of RAM on the server. All of the settings for memory are left to their defaults.
When the SSAS service starts, it behaves normally. However, whenever a query is run against the instance, the SSAS service continually will consume all of the memory on the server, to the point that the server needs to be rebooted. At present, the TotalMemoryLimit and LowMemoryLimit settings are set to 80% and 75% respectively. The HardMemoryLimit is set to 0 by default.
Why is SSAS using all of the memory on the server, despite the limit settings? Does HardMemoryLimit need to be set?
I would check the perfmon counters to confirm what is exactly using the memory – It is not clear if you are using task manager to identify the use.
Analysis Service should peak out its memory at the total memory limit.
Do the queries continue to run? – why do you have to reboot? is it to kill the ongoing queries?
I would check the cleaner counters to see if the issue is there – ultimately you may just need to add more memory for the queries you are running or take a look at your cube designs
Check more discussion of this question.
