The default behavior for processing cubes is to let the server determine how much parallelism to use. Let’s face it, the server must’ve not learned to play nice with others as a kid; as such, it doesn’t always make the best decisions. But fear not, you can help it along.
When processing a cube, click on “Change Settings…”
SSAS Cube Processing
Now change the “Maximum parallel tasks” to 1, 2, or whatever is appropriate for your environment:
SSAS Cube Processing Settings
That’s all there is to it. Happy cube processing!
To make it the default option you can change it trough Management Studio, after connecting to an instance of Analysis services > Right-click on it > Options. Mark ‘show advanced options’ and you’ll see a lot more options. To change parallelism level change this one OLAP/LazyProcessing/MaxObjectsInParallel (I think, I’m not completely sure).
Cheers from argentina
Great blog btw.
Thanks, Alan! I always appreciate learning new things. Thanks for taking the time to leave me a comment.
Pingback: Something for the weekend 24/07/09 | John Sansom - SQL Server DBA in the UK
Pingback: Something for the weekend 24/07/09