Friday, March 9, 2012

Larger Scale SSAS 2005 deployment configuration options...

I'm wondering if there is anything like

Microsoft SQL Server 2000 Analysis Services Operations Guide.doc

Microsoft SQL Server 2000 Analysis Services Performance Guide.doc

for SSAS 2005. I'm working on a 22 Gig cube (that is size with no aggs) with a 32-Gig RAM Server and want to do more tuning - I should be able to get the whole thing in RAM, no? Shouldn't that make it really fast? I'm particularly interested in all of the Analysis Services Properties for SSAS.

What does "-3000" mean for several of the properties? I was thinking that raising many of the max RAM settings could be good, but if they are based on percentages, then that would scale with the server and wouldn't need tuning. There seems to be extremely little info. I see the basic info on 3 or 4 of the RAM settings with the percentages, I want much more than that.

I've looked around and read/skimmed 3 books, but few go into how to deploy to 32 Gigs of RAM / 8 processors and get the best use of the system...

So I'm looking either for direction on a paper or book I've missed or for specific help - both are good. Feel free to mention property changes you've implemented and that worked for you here!

Some information for you:

Server configuration properties docuement is found here: http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/SSASProperties.doc

Project REAL implementation references have a lot of useful information: http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment