Cube Storage: Planning Partitions (Business Intelligence Development Studio Perspective)

...
In this article, we will continue the general exploration of cube storage that we began in Cube Storage: Introduction, this time focusing upon partitions, which we initially introduced in Cube Storage: Introduction to Partitions. This article is one of several others in this subseries that explore various concepts surrounding partitions in Analysis Services. Here we will discuss partition planning considerations and how they are important to partition design within our business intelligence solutions, touching upon points that include the following:

• A discussion of partition planning in general in Analysis Services;
• A discussion of each of several individual resource assignment and settings considerations in planning Partition design within Analysis Services;
• A hands-on examination, from within the Cube Designer of the Business Intelligence Development Studio, where applicable, of a respective example resource assignment / setting from the Adventure Works sample cube, for each of the resource assignment and settings considerations we discuss.

Read more...