SSAS and SQL optimal settings - maxdops, max degree of parallelism, max server memory

by Jason   Last Updated August 02, 2017 18:06 PM

I have 4 cubes running on the SSAS server. The cpu seems to peg and we had memory issues with the 4th cube during loads. We have 4 cpus with maxdops set at 2, max degree of parallelism = 70, we added Server memory 68GB to 96GB with max server memory from 33GB to 44GB. I had max SQL server memory higher, but looks like OS and other processes were causing memory issues, so I lowered it to 44GB. Is there a great article to help with SSAS and optimal settings? I would like to adjust so we don't throw un-needed cpus and memory at it if possible.



Related Questions





Can't modify FormatString on cube ( SSAS )

Updated February 22, 2017 12:06 PM



Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-7-182530-ssas-and-sql-optimal-settings-maxdops-max-degree-of-parallelism-max-server-memory- could not be written