SQL Server Performance Forum – Threads Archive

Trying to understand Cube Partitions

Hi, 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. Regards.

Joozh, 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. Howard.

Thanks Howard. Will go through the suggested URL. Regards.

]]>