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…