Report Portal

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


2007-2015 VidasSoft Systems Inc.