adCenter and SSAS 2008 White Paper

There’s a new white paper on how adCenter uses Analysis Services 2008 available here:

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.

2 responses

  1. 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?

  2. 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 🙂

Leave a Reply to Frank Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: