Analysis Services 2005 Performance Guide
The highly-anticipated Analysis Services 2005 performance whitepaper is finally here. I found a few things intresting glancing at it:
- This is a colossal work spanning some 120 pages (no wonder it took so long [:)].
- The guide was written by the top architects on the SSAS team.
- It specifically references SQL Server 2005 SP2 probably because SP2 brings many performance optimizations to SSAS.
- The guide mentions a new aggregation utility (Appendix C) which you can use to manually create aggregation designs.
Something to sure keep me busy when the winter storm hits Atlanta tomorrow…