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