Hi
I have a tabular database on a SSAS 2012 instance that is 2.2Gb in size. When we do a full process on one of the table's last partition (table is partitioned per month) the memory usage shoots up from 2.8Gb to 110Gb. I did set the memory limits to try and limit the usage to 70Gb but I assume that the settings does not apply to processing as it still uses everything it can get. My issues is that when the memory usage is too high it causes issues on my cluster.
Does anyone know why the memory usage will be so high during processing?
Is there a way I can limit the memory usage so that SSAS processing does not impact SQL instances?
Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>