October 28, 2014 at 6:21 am
We have a 2 core server 2008r2 with sql 2008r2. We recently added 2 more cores and are seeing reduced execution times for everything except the cube still takes the same time. The analysis server properties are set at all defaults. Does anyone know why it still takes the same time?
There is an exception to every rule, except this one...
October 28, 2014 at 6:26 am
How do you process the cube?
Make sure parallellism is used.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2014 at 6:42 am
It's processed from a package on our job server to the upgraded server. The settings are currently default for the analysis server processing task editor object in the package. Under Processing Settings, I can see the processing order is Sequential, should it be set to Parallel?
There is an exception to every rule, except this one...
October 28, 2014 at 7:02 am
SQLHeap (10/28/2014)
It's processed from a package on our job server to the upgraded server. The settings are currently default for the analysis server processing task editor object in the package. Under Processing Settings, I can see the processing order is Sequential, should it be set to Parallel?
Yes! 😀
Otherwise your new cores are just sitting idle.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply