There’s a new white paper on how adCenter uses Analysis Services 2008 available here:
http://technet.microsoft.com/en-us/library/ee410017.aspx
For the most part it’s a fairly run-of-the-mill list of reasons to upgrade to 2008 (and, to be honest, if you’re running 2005 I can’t think of a good reason not to upgrade to 2008 – the performance is so much better) but there are several good nuggets on performance tuning for large SSAS implementations; for example, table 3 has a list of ini file settings for optimising processing. Worth a look.
Chris I noticed that under the PreAllocate setting in the adCenter document that it states "increasing this parameter may also increase the size of your data". I have used this setting before in 2005 and I don\’t ever remember it "increasing the size of my data". Do you know what they mean by this? Is this a typo?
Frank – I have no idea what that means either, I can\’t see how using PreAllocate can increase the size of your data. Sergey – thanks for the gossip 🙂