Analysis Services Partition Size
User Rating: / 0
Written by Richard Tkachuk   
Monday, 23 March 2009 00:42

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.”




XL Cubed