SQLBits 2011

Performance Tuning Large Analysis Services Cubes

Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.

If you have any Analysis Services cube, you'll know how important it is to properly design, set up and tune the cube.  This session explains how to appropriately deal with dimension design and hierarchy relationships, cube partitioning, how to deal with many-to-many relationships and how to design aggregations which take advantage of all the design decisions you've made in order to wring out every last drop of performance from your cube.

Inspired by a recent journey to the shores of a one terabyte cube, the session includes code demonstrations as well as lots of practical tips which you can take away and put into real-life usage.