Re: Installation Question

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

Date: Mon, 12 Jul 2004 16:55:20 -0700

I can't answer that in the general case. It is dependent on the resources
used. 

-- 
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:9CB7636C-B740-4FD8-8FB1-441BD01A281A@microsoft.com...
> Dave,
>
>    What is the recommended server configuration for an organization that
wishes to use all three applications in a production environment? Would it
be best to have each application installed on a separate server?
>
> Attila
>
>
> "Dave Wickert [MSFT]" wrote:
>
> > 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
    ... Each server application has its own resource allocation technique. ... suppose you have 8GB of memory -- ... For Analysis Services, if you use Analysis Manager and right-click on the ...
    (microsoft.public.sqlserver.olap)
Loading