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

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?

    Frank

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

    Chris

    September 26, 2009 at 9:33 pm


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

Follow

Get every new post delivered to your Inbox.

Join 3,081 other followers

%d bloggers like this: