Analysis Server 2000 memory vs. SQL Server 2000 memory

Here is the situation:
Server is installed with both Analysis Services(OLAP
Cubes) and SQL Server 2000. O/S is Windows Advanced
Server 2000. Server currently has 6 GB of RAM. AWE
extension is used with 5 GB of RAM allocated to SQL
Server.
Does this mean only 1 GB of RAM is left for Analysis
Services and O/S? What is the max RAM can be allocated to
Analysis Services in a Windows 2000 Advanced Server?
Need to understand why at times (once a month) we
encounter "running low on virtual memory" on this server
causing DTS packages to stall occasionally. Realize that
best practice is to separate OLAP server from SQL Server,
but budget is a limitation at this time.Steven,
Analysis Services 32-bit edition uses up to 2GB memory. It can be exapanded
up to 3GB (check the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;295443 how to do
it). So in your case, AS and SQL are competing for the same memory. Maybe
you could limit SQL Server on 4GB, so you have 2GB for AS.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Steven Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:02e501c48af8$b4cc31e0$a601280a@.phx.gbl...
> Here is the situation:
> Server is installed with both Analysis Services(OLAP
> Cubes) and SQL Server 2000. O/S is Windows Advanced
> Server 2000. Server currently has 6 GB of RAM. AWE
> extension is used with 5 GB of RAM allocated to SQL
> Server.
> Does this mean only 1 GB of RAM is left for Analysis
> Services and O/S? What is the max RAM can be allocated to
> Analysis Services in a Windows 2000 Advanced Server?
> Need to understand why at times (once a month) we
> encounter "running low on virtual memory" on this server
> causing DTS packages to stall occasionally. Realize that
> best practice is to separate OLAP server from SQL Server,
> but budget is a limitation at this time.
>|||Hi Dejan:
Thanks for your response. Just want to clarify....
Is AS and SQL competing for the memory OR AS only has up
to 1 GB of RAM to use since AWE is enabled with 5 GB
allocated to SQL in this case?
How about the option to add 2 GB of RAM to server, and
allocate 6 GB to SQL and leave 2 GB to AS? What do you
think?
Thanks in advance.
>--Original Message--
>Steven,
>Analysis Services 32-bit edition uses up to 2GB memory.
It can be exapanded
>up to 3GB (check the article at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;295443 how to do
>it). So in your case, AS and SQL are competing for the
same memory. Maybe
>you could limit SQL Server on 4GB, so you have 2GB for AS.
>--
>Dejan Sarka, SQL Server MVP
>Associate Mentor
>Solid Quality Learning
>More than just Training
>www.SolidQualityLearning.com
>"Steven Wong" <anonymous@.discussions.microsoft.com> wrote
in message
>news:02e501c48af8$b4cc31e0$a601280a@.phx.gbl...
>> Here is the situation:
>> Server is installed with both Analysis Services(OLAP
>> Cubes) and SQL Server 2000. O/S is Windows Advanced
>> Server 2000. Server currently has 6 GB of RAM. AWE
>> extension is used with 5 GB of RAM allocated to SQL
>> Server.
>> Does this mean only 1 GB of RAM is left for Analysis
>> Services and O/S? What is the max RAM can be allocated
to
>> Analysis Services in a Windows 2000 Advanced Server?
>> Need to understand why at times (once a month) we
>> encounter "running low on virtual memory" on this server
>> causing DTS packages to stall occasionally. Realize
that
>> best practice is to separate OLAP server from SQL
Server,
>> but budget is a limitation at this time.
>
>.
>|||> Is AS and SQL competing for the memory OR AS only has up
> to 1 GB of RAM to use since AWE is enabled with 5 GB
> allocated to SQL in this case?
I think they are competing for the first 4 GB.
> How about the option to add 2 GB of RAM to server, and
> allocate 6 GB to SQL and leave 2 GB to AS? What do you
> think?
This would be even better than limiting SQL Server :-)
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com