Consolidate partitions for measure groups with 5 or more partitions that have less than 2 million rows or are smaller than 50 MB in size

This rule analyzes partitions to determine whether existing partitions are too small. A measure group that contains five or more partitions is too small if the measure group meets one of the following conditions:

  • Has an estimated count of less than 2 million rows.

  • Has an estimated size of less than 50 MB per partition.

Best Practices Recommendations

For best performance, you should typically consolidate partitions that are too small.

For More Information

For more information about how to design aggregations, see Designing Partition Storage and Aggregations in SQL Server Books Online.

For more information about performance related to partitioning, see the section, "Designing partitions," in the SQL Server 2005 Analysis Services Performance Guide.