Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / March 2005

Tip: Looking for answers? Try searching our database.

where to install RS when I have 2 servers...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J?j? - 25 Mar 2005 00:28 GMT
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.
Jeff A. Stucker - 25 Mar 2005 04:44 GMT
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.

Signature

Cheers,

'('    Jeff A. Stucker
\

> Hi,
>
[quoted text clipped - 13 lines]
>
> Jerome.
Phil Austin - 25 Mar 2005 11:59 GMT
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.

> 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
[quoted text clipped - 29 lines]
> >
> > Jerome.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.