SSAS Articles Performance Tuning Designing Effective Aggregations in AS2005 (by Chris Webb)
Designing Effective Aggregations in AS2005 (by Chris Webb)
User Rating: / 0
PoorBest 
Written by Chris Webb   
Saturday, 19 May 2007 18:25
Aggregations are, as we all know, the key to getting the best performance out of your cube. In AS2K it was usually enough to run the Aggregation Design Wizard to get a reasonable aggregation design; in my experience with AS2005 it's much harder to achieve good results - a lot of people run the wizard and find that performance is still poor. So what I thought I'd do is detail the process I go through when I'm designing aggregations...

Read more...