Hi All,

We are running OLTP and OLAP on same box, SQL Server 2000 Standard
Edition on win server 2003. There are 70 OLTP users and 5 OLAP user
using Crystal Analysis Services.
ETL and Process Cube is done during lunch time.

Now we are running with 2 GB.
During working hours, we chech that from Task manager only 500KB RAM
Available.

Given this situation, approximately how much RAM do we need ?

I read that SQL Server 2000 Std Ed only support 2 GB, If we add 1 GB
more can Analysis Services make use of it ?

Thank you,
xtanto

if you don't force some memory options, the system will manage and share the
memory by him self regarding the most demanding application.
AS2000 required some memory to load the dimension because the system load
and keep the dimension in the RAM.
So more dimension you have and if these dimensions are big, more memory you
need.

500Kb of free memory, your server should swap a lot on the disks!

if you can, put 4Gb to insure that the system + the applications will have
enough memory and can cache more data. but if your not ready to buy 2Gb,
test and growth...
but Any Mb of Ram added will help the system.


<krislioe (AT) gmail (DOT) com> wrote

Hi,

If we do add up to 4 GB, how is the break down ?

Can we say it like this :

2 GB SQL Server (as it is the limit of STd Edition )
1 GB for Analysis Services
1 GB for OS and others.

Can it be like that ?

Thank you,
xto




Jeje menuliskan:

That should work fine. I would be tempted to push it to 2GB -OLTP, 1.5 GB
OLAP, .5GB OS.

Large multi-dimensional cubes will eat up a lot of memory.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


<krislioe (AT) gmail (DOT) com> wrote

start by doing nothing special to see how the memory is shared among all the
applications.
then optimize the memory usage.
controlling the memory used by AS is difficult, but controlling the SQL
memory is easy (setup the minimum and maximum memory available and you are
on track)

<krislioe (AT) gmail (DOT) com> wrote