Hello everyone,

We are planning to purchase hardware for Analysis Server. I want to see
what configuration everyone is using for the Analysis Server. How much RAM
on your server, how many processors, size of the cub, Server edition, etc...

Someone indicates that we need 64 bit SQL Server 2005 for Analysis to access
> 3 GB RAM. I don't buy this.

Please help me out, thanks!

Donald

On Oct 30, 10:07 am, "Donald" <dona...@gmail.com> wrote:
> Hello everyone,
>
> We are planning to purchase hardware for Analysis Server. I want to see
> what configuration everyone is using for the Analysis Server. How much RAM
> on your server, how many processors, size of the cub, Server edition, etc...
>
> Someone indicates that we need 64 bit SQL Server 2005 for Analysis to access
> > 3 GB RAM. I don't buy this.
>
> Please help me out, thanks!
>
> Donald

According to Microsoft:

http://www.microsoft.com/sql/prodinf...-features.mspx
http://technet.microsoft.com/en-us/w.../bb430827.aspx

The maximum amount of RAM that SQL Server can use is determined by:

1) Edition of SQL Server (ex: Express, Workgroup, Standard,
Enterprise)
2) Operating System
3) Platform (ex: x32, x64, ia64)

Cross reference the above documentation and you should be able to
determine the maximum available for any given configuration.