SQL Server Performance

Trying to understand Cube Partitions

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Mar 8, 2005.

  1. Joozh New Member


    I'm a bit confused after coming across a few posts on the net where people seem to be talking about "multiple cube partitions" and "making new partitions".

    The reason I'm confused is becuase I have only one partition in my cube and that too was not made manually but rather was made automatically when I first made the cube. Does this mean that my cube is "incorrect" sinceit has only 1 partition[?]

    Is there some article which can help me better understand the concept of cube partitions? When should one try to manually make new partitions?

    Any guidance and push in the right direction in this regard is requestedand will be appreciated.

  2. wildh New Member


    You not doing anything wrong, multiple partitions are there for performance reasons. Yes you can partition any cube but that also means more admin. I would suggest you read the article below and if you have and performance concerns (build time/ query response times etc.) to implement a partition strategy.

    Have a read of -http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2661.mspx

    There is a section called partition strategy.

    Hope this is a good start.

  3. Joozh New Member

    Thanks Howard. Will go through the suggested URL.


Share This Page