AS server performance question

Hi,

We have a SQL Server 2005 server that runs database/AS/RS/IS all on
one box. The database has about 10 fact tables and lots of small
dimension tables. The biggest fact table has 17 million records. There
are about 10 OLAP cubes running on the same server. The biggest one
has 15 dimensions defined, and the server still can process this cube.
But when I add 15 more dimension into this cube, when it's been
processed, it always hang out at the step reading data from fact
table. It seems due to memory shortage, as sqlservr.exe uses 3g ram
out of the total 3.5g ram, and seems still waiting for more memory.
Here is my server configuration.

Intel Xero(TM) CPU 3.8GHz
3.50 GB RAM
3.5 TB hard drive

My question is if we should upgrade the server. What's the
recommendation of the server for this type of OLAP server?

Thanks very much for any suggestion.

Hi,

The better the HW the better performance.
I am assuming the server is x86 (32-bits). What is the memory using by SSAS?

Add memory to the server. With the /3GB OS parameter each process can use up
to 3 GB and 1 GB for the OS. But it may depend on the OS and its version.
E.g., we have Xeon servers with 12 GB running W2K3 Enterprise Edition.

There are some parameters that you have to change after adding the memory.
See http://forums.microsoft.com/MSDN/Sho...69573&SiteID=1.

Hope it helps,
Tiago


"Oliver" wrote:

> Hi,
>
> We have a SQL Server 2005 server that runs database/AS/RS/IS all on
> one box. The database has about 10 fact tables and lots of small
> dimension tables. The biggest fact table has 17 million records. There
> are about 10 OLAP cubes running on the same server. The biggest one
> has 15 dimensions defined, and the server still can process this cube.
> But when I add 15 more dimension into this cube, when it's been
> processed, it always hang out at the step reading data from fact
> table. It seems due to memory shortage, as sqlservr.exe uses 3g ram
> out of the total 3.5g ram, and seems still waiting for more memory.
> Here is my server configuration.
>
> Intel Xero(TM) CPU 3.8GHz
> 3.50 GB RAM
> 3.5 TB hard drive
>
> My question is if we should upgrade the server. What's the
> recommendation of the server for this type of OLAP server?
>
> Thanks very much for any suggestion.
>