Max Parallelism on Cube Processing

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

SSAS Cube Processing

Now change the “Maximum parallel tasks” to 1, 2, or whatever is appropriate for your environment:

SSAS Cube Processing Settings

SSAS Cube Processing Settings

That’s all there is to it. Happy cube processing!

0saves
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Tagged , , , , . Bookmark the permalink.

4 Responses to Max Parallelism on Cube Processing

  1. Alan Featherston Lago says:

    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.

  2. Thanks, Alan! I always appreciate learning new things. Thanks for taking the time to leave me a comment. :)

  3. Pingback: Something for the weekend 24/07/09 | John Sansom - SQL Server DBA in the UK

  4. Pingback: Something for the weekend 24/07/09

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>