Hi,

I have to prepare a deployment plan for a data warehouse solution which
include this:
* 1 Data warehouse server (SQL Server 2000) for a 32 gb database / 4
processors
* 1 OLAP Server (Analysis Services) / 2 processors

My reports target the database himself, the olap cubes are here for custom
and ad-hoc analysis not used in reports, but this will changed.

Where I have to install RS?
on the olap server or the DW server himself?

thanks.

Jerome.

There is no "standard" answer to this question. You could put reporting
services on either box, or on its own box. If both of these database
servers have a heavy load, you probably want to put reporting services on
its own box. Remember that reporting services requires IIS, which will add
to the overhead on whatever machine you locate it on, and may have
infrastructure implications beyond just the database load.

If one of the servers is SQL Standard, and the other SQL Enterprise, and you
want to use forms-based authentication to protect your reporting solution,
but you don't want to buy another Enterprise license, then you'll need to
put it on the Enterprise box.

Again, there are too many variables to put out a standard answer. Every
deployment is unique, particularly the large-scale data warehouse
deployments.

--
Cheers,

'(' Jeff A. Stucker
\

"Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
news:eXXfhkMMFHA.3708@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have to prepare a deployment plan for a data warehouse solution which
> include this:
> * 1 Data warehouse server (SQL Server 2000) for a 32 gb database / 4
> processors
> * 1 OLAP Server (Analysis Services) / 2 processors
>
> My reports target the database himself, the olap cubes are here for custom
> and ad-hoc analysis not used in reports, but this will changed.
>
> Where I have to install RS?
> on the olap server or the DW server himself?
>
> thanks.
>
> Jerome.
>
>

If extra boxes aren't an option you may also want to consider placing RS on
the 2 CPU box and putting AS on the 4 CPU server along with your data
warehouse. AS is very memory intensive and although you don't say how much
memory each server has I'm guessing that the 4-way has considerably more
than the 2-way. You'll also eliminate the network traffic between the data
warehouse and the AS machine every time the cubes are processed which may be
a bottleneck.

The best advice is to test a number of configurations if you have the
time...

Phil.

"Jeff A. Stucker" <jeff@mobilize.net> wrote in message
news:%23GLjT0OMFHA.3340@TK2MSFTNGP14.phx.gbl...
> There is no "standard" answer to this question. You could put reporting
> services on either box, or on its own box. If both of these database
> servers have a heavy load, you probably want to put reporting services on
> its own box. Remember that reporting services requires IIS, which will
add
> to the overhead on whatever machine you locate it on, and may have
> infrastructure implications beyond just the database load.
>
> If one of the servers is SQL Standard, and the other SQL Enterprise, and
you
> want to use forms-based authentication to protect your reporting solution,
> but you don't want to buy another Enterprise license, then you'll need to
> put it on the Enterprise box.
>
> Again, there are too many variables to put out a standard answer. Every
> deployment is unique, particularly the large-scale data warehouse
> deployments.
>
> --
> Cheers,
>
> '(' Jeff A. Stucker
> \
>
> "Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
> news:eXXfhkMMFHA.3708@TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > I have to prepare a deployment plan for a data warehouse solution which
> > include this:
> > * 1 Data warehouse server (SQL Server 2000) for a 32 gb database / 4
> > processors
> > * 1 OLAP Server (Analysis Services) / 2 processors
> >
> > My reports target the database himself, the olap cubes are here for cust
om
> > and ad-hoc analysis not used in reports, but this will changed.
> >
> > Where I have to install RS?
> > on the olap server or the DW server himself?
> >
> > thanks.
> >
> > Jerome.
> >
> >
>
>