Expert Cube Development with SSAS Multidimensional Models

Scale-up and Scale-out

Buying better or more hardware, that is to say "scaling up", should be your last resort when trying to solve query performance problems. It's expensive and you need to be completely sure that it will indeed improve matters. Adding more memory will increase the space available for caching but nothing else; adding more or faster CPUs will lead to faster queries but you might be better off investing time in building more aggregations or tuning your MDX. Scaling up as much as your hardware budget allows is a good idea but may have little impact on the performance of individual problem queries unless you badly under-specified your Analysis Services server in the first place.

If your query performance degenerates as the number ...