Re: Installation Question

From: Attila (Attila_at_discussions.microsoft.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 05:55:01 -0700

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

  • Analysis Services
    ... with the Analysis Services of that version, in a Production Server... ... We don`t have any problem to register the OLAP Production Server in the ...
    (microsoft.public.sqlserver.olap)
  • Business Intelligencia and the Authentication mountain
    ... analysis services on the production server? ... Just in case the server is ... What do I use as the connection in my ETL process at the point ... I am currently using the "Analysis Services ...
    (microsoft.public.sqlserver.datawarehouse)
  • Tell Me About Your DW Development Life Cycle
    ... What are some good ways to get development cubes into ... I currently use a developer's edition of SQL Server 2000 ... Connect to the production server via VPN and run the ... Analysis Services Server and rebuild cubes. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Installation Question
    ... It is just that in production you may have to spend some time getting your ... SQL BI Product Unit (Analysis Services) ... "Attila" wrote in message ... SQL Server 2000 and Reporting Services. ...
    (microsoft.public.sqlserver.olap)
  • Re: Installation Question
    ... Attila ... > 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 ... >> I'm looking to install Analysis Services on a server that is running both ...
    (microsoft.public.sqlserver.olap)
Loading