22Jul/092
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
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!
Categories
- Business Intelligence
- Internals
- Miscellaneous
- PASS
- Performance & Tuning
- Presentations
- SQL 2008
- SQL Tips
- Syndication
- T-SQL Scripts
Subscribe to my blog!
| Like what you see? Subscribe! |
 |
Around the Web
Recent Tweets
- @gregsohl yeah, that would be a nice feature. Did you find any products that do support field-level dependencies?
- @MladenPrajdic @atlantis_uk Thanks, Mladen, I'll be sure to check that out. :)
- I'm really lovin' @RedGate's #SQL Dependency Tracker. I can see it saving me a *lot* of time once I figure out what the heck I'm doing :)
Archives
- November 2011
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
July 22nd, 2009 - 09:46
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.
July 22nd, 2009 - 16:04
Thanks, Alan! I always appreciate learning new things. Thanks for taking the time to leave me a comment.