Report Portal

Creating and managing SQL Server Analysis Services partitions

Partitions are portions of a SQL Server Analysis Services measure group that hold some or all of the measure group's data.


When a measure group is first created, it contains a single partition corresponding to all the data in your fact table or view. Additional partitions need to be created for any measure group with more than 20 million rows.

Since a majority of corporate databases have far more than 20 million rows in fact tables, you should know how to create partitions and also be aware of good partition design practices.


Tags: partition, management


2007-2015 VidasSoft Systems Inc.