Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

adCenter and SSAS 2008 White Paper

with 2 comments

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.

Written by Chris Webb

September 20, 2009 at 9:19 pm

Posted in Analysis Services

2 Responses

Subscribe to comments with RSS.

  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?


    September 24, 2009 at 3:24 pm

  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 :-)


    September 26, 2009 at 9:33 pm

Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s


Get every new post delivered to your Inbox.

Join 3,962 other followers

%d bloggers like this: