Re: Analysis Server 2000 memory vs. SQL Server 2000 memory

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 08:17:06 +0200

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.
>

Relevant Pages

  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • Re: FTS Performance in SQL 2005
    ... I don't think you have left enough memory for the OS and MSSearch. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Insufficient memory Available
    ... Insufficient memory available. ... within the scope of SQL Server. ... "MemToLeave" area. ...
    (microsoft.public.sqlserver.server)
  • RE: server problems
    ... This newsgroup only focuses on SBS technical issues. ... >Thread-Topic: server problems ... >> web proxy service or SQL Server will normally use large memory. ...
    (microsoft.public.windows.server.sbs)
  • RE: server problems
    ... > web proxy service or SQL Server will normally use large memory. ... > the SBS server and sends the alert when the value reaches the threshold. ...
    (microsoft.public.windows.server.sbs)