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…