Search code examples
ssaspartitioning

SSAS Partitions, how many is too many

I am adding partitions to my SSAS cube, and I want to know if there is a number of partitions to stay under? How many is too many, is the best practice limit at 20 or 200? Does anyone have any real world knowledge they can share?

Solution

  • Here's another article (by Duncan Sutcliffe) with a section on partitioning.

    Also, you will want to consider the overhead requried for managing different partitioning strategies. If you end up with a lot of partitions, it can be a really P.I.T.A. to manage and so you will probably want to implement some sort of SSIS/Script solution to automate the process of creating partitions.

    What you ultimately decide to do will be environment-specific, but between the article you posted and the one by Duncan (above) you should have a pretty good (high-level) idea of the considerations to factor into the decision and which levers are at your disposal.