Analysis Services Partition Size
Thomas and I updated the SQL Server 2008 Analysis Services Performance Guide principally to address features available in the latest release. But there was one important change related to partition size driven by changes in hardware. The earlier version of the performance guide for SQL Server 2005 Analysis Services Performance Guide stated this:
“In general, the number of records per partition should not exceed 20 million. In addition, the size of a partition should not exceed 250 MB.”
Tags: design, performance