Sunday, July 11, 2010

SSAS Query Performance Top 10 Best Practices

Optimize cube and measure group design.
Define effective aggregations.
Use partitions.
Write efficient MDX.
Use the query engine cache efficiently.
Ensure flexible aggregations are available to answer queries.
Tune memory usage.
Tune processor usage.
Scale up where possible.
Scale out when you can no longer scale up.