Re: Installation Question

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 16:56:40 -0700

Each server application has its own resource allocation technique.

Since you are looking to run all 3 in production on the same box, it might
require by-hand allocation. For example, suppose you have 8GB of memory --
you might want to allocate 3GB to the RDBMS, 2GB to Analysis Services; 2GB
to Reporting Services (and don't forget at least 1GB for the OS and other
related processes running on the box).

For Analysis Services, if you use Analysis Manager and right-click on the
server name, select "Properties..." and then look at the Environment tab you
will see the high and low memory allocation which Analysis Services will
use. This is virtual memory allocation, but unless you are willing to take a
tremendous amount of page faults, it roughly maps to physical memory also.
By default, Analysis Services is installed with high memory set to the
amount of memory on the machine (up to 2GB) and low memory at 1/2 of that
value. See the Analysis Services Operations Guide
(http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.msp
x ) under the section "Configuration Management".

The SQL Server RDBMS will, by default, attempt to allocate all physical
memory that it can -- and then back off if the computer page fault rate goes
too high. It keeps backing off until the system stabalizes. While this is OK
for an interactive computer, it isn't good if you are using other server
applications on the same box as this takes time and is variable over when it
runs. So in that case you might decide to tune the RDBMS memory allocation
by-hand. This means setting the memory options maually,see BOL under the
topic "Server Memory Options" for a detailed discussion of how to do this
and the implications.

Reporting Services as a web service uses memory allocation based on its IIS
virtual directory and the IIS web site that it is running under. 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Attila" <Attila@discussions.microsoft.com> wrote in message
news:B97CAB95-A8E8-4ACE-9FB4-10B9FE42A627@microsoft.com...
> Dave,
>
> Thanks for the response. Can you elaborate on what you mean by getting the
memory allocation right? How do I allocate memory to a specific application?
>
> Attila
>
>
> "Dave Wickert [MSFT]" wrote:
>
> > There is no technical reason why not. I run it on my machines like that
all
> > of the time.
> > It is just that in production you may have to spend some time getting
your
> > memory allocation right because all three can consume heavy amounts of
> > memory and CPU from time to time (as they are server-based products).
> > -- 
> > Dave Wickert [MSFT]
> > dwickert@online.microsoft.com
> > Program Manager
> > BI SystemsTeam
> > SQL BI Product Unit (Analysis Services)
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Attila" <Attila@discussions.microsoft.com> wrote in message
> > news:154D2F8A-F67B-4E3F-82C9-B4E20F8E2C1A@microsoft.com...
> > > Hello,
> > >
> > > I'm looking to install Analysis Services on a server that is running
both
> > SQL Server 2000 and Reporting Services. While I don't think this should
> > cause any problems, I was hoping that others would comment based on
their
> > own experiences. Your input would be much appreciated.
> > >
> > > Thanks,
> > > Attila
> > >
> >
> >
> >

Relevant Pages

  • Re: Allocated Memory alerts
    ... If you do not encounter any real server performance issue, ... the high memory usage is expected. ... The Health monitor is running on the SBS server. ... A memory allocation threshold is configured on the particular monitored ...
    (microsoft.public.windows.server.sbs)
  • Re: Quick question - dimensions large relative to fact table size
    ... that will improve memory headroom. ... Windows Server 2003 Standard Edition can address a maximum of 2 ... Analysis Services may require more than 2 GB to ... load dimensions into memory, process dimensions, load replica ...
    (microsoft.public.sqlserver.olap)
  • Re: 64-bit memory consumption
    ... because of GC memory compaction, ... *improved* over manual allocation. ... Well, this doesn't really have to be expected, 'old' compiler technology ... server, your cache is shared by multiple applications, and you can't ...
    (borland.public.delphi.non-technical)
  • RE: Upgrade RAM to 3GB now getting Allocated Memory Alert
    ... Thanks for using the SBS newsgroup. ... I understand that you received "Allocated Memory ... This alert in the Server performance report indicated that some ... A memory allocation threshold is configured on the particular monitored ...
    (microsoft.public.windows.server.sbs)
  • Re: Installation Question
    ... SQL BI Product Unit (Analysis Services) ... be best to have each application installed on a separate server? ... >> Each server application has its own resource allocation technique. ... >> will see the high and low memory allocation which Analysis Services will ...
    (microsoft.public.sqlserver.olap)