Is there a guideline or magic "formula" that can be used to determine how
many CPUs and how much memory a server should be equipped with to handle a
cube of a certain size? For example, If I have cube containing 500,000,000
fact table records and 10 Dimensions with an average member size of 200
members; how can I estimate how many CPUs (of what type) and how much RAM I
should have in my server?

There was a tool called "Compaq ProLiant Sizer for Microsoft SQL Server 2000
BI"

I'm not sure this is exact what you want. Unfortunately, I don't know where
it is now, but probably someone has it.

Ohjoo Kwon


"Matt" <Matt (AT) discussions (DOT) microsoft.com> wrote