Hi all,
we use SSRS based on SSAS Cubes.
We thought about installing SSAS on one server, the relational data on an
other SQL Server and put the Report Server with the IIS 6.0 on a third
machine.
As we haven't any experiences with load and performance for BI-Applications
I'm wondering how many memory we should buy for each server.
The idea of our system service is the following:
32 GB for the analysis server
16 GB for the relational database server
4 GB for the web and reporting server
I have the impression that the 4 GB for the web/reporting server is too few,
but memory for the two others sounds pretty good.
What do you say?
Thanks a lot for any answers...
Cheers
MarcYou didn't talk about the expected load on the server and the number of
CPU's. My experience is that 4 GB is fine but I would want multiple CPUs. If
you design the way you should (i.e. limit the data at the source and limit
the report to what the user needs to see) then that configuration will be
pretty darn good. I would look at 4 CPU (but again, it depends on your
load).
Without knowing the load (expected number of reports per hour for instance),
it is really hard to say.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marc" <Marc@.discussions.microsoft.com> wrote in message
news:17E86835-FF86-429F-8424-A7BE431093B1@.microsoft.com...
> Hi all,
> we use SSRS based on SSAS Cubes.
> We thought about installing SSAS on one server, the relational data on an
> other SQL Server and put the Report Server with the IIS 6.0 on a third
> machine.
> As we haven't any experiences with load and performance for
> BI-Applications
> I'm wondering how many memory we should buy for each server.
> The idea of our system service is the following:
> 32 GB for the analysis server
> 16 GB for the relational database server
> 4 GB for the web and reporting server
> I have the impression that the 4 GB for the web/reporting server is too
> few,
> but memory for the two others sounds pretty good.
>
> What do you say?
> Thanks a lot for any answers...
>
> Cheers
> Marc
Friday, March 9, 2012
Hardware considerations for Report Server?
Labels:
based,
considerations,
cubes,
database,
hardware,
installing,
microsoft,
mysql,
oracle,
relational,
report,
server,
sql,
ssas,
ssrs
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment