Problem – Analysis Services 2005 generates thousands of mini dumps when you are processing objects overnight.
Environment – Analysis Services 2005 x64, 8GB of RAM
Root Cause – When the server process objects, it requires more memory, and the server is under memory pressure. The server cache cleanup threads will start cleaning up some cache to free up some memory, but it encounter heap corruption issue and generates the mini dumps every time it encounters the corruption. The server system cache is another cause of the memory pressure. In a 64-bit system, the server opens files in the system cache by default. Over time the system cache will take more and more memory if there is no limit on how much it can take, then it leads to server out of memory. Analysis Services needs to open files in order to read and write data during processing, so the part of the system cache is indirectly used by the Analysis Services.
Resolution – To limit the system cache, you need to change the server properties in the msmdsrv.ini file as the following to limit the system cache to 2.5GB:
To fix the OLAP heap corruption issue, you will need to use the following settings to let the Analysis Services to use the Windows Low Fragmentation Heap instead of the OLAP heap.
MemoryHeapType: set this to 2
HeapTypeForObjects: set this to 0
All these settings requires the OLAP service to restart.