August 7, 2010 at 11:46 pm
Hello,
i have 1 machine with SQL Server 2008 R2, this machine is used for DWH database and SSIS process.
i'm want to install on a different machine reporting services, my question is which DB should i use? a local or remote?
are there any advantages when a remoteDB is being used over a localDB?
thanks,
Dave.
September 7, 2010 at 10:11 am
I can answer with a link:
They have articles about scale-out architecture, placing the report catalog (the reporting services databases) best practices, etc...
If you are going to have more than 1 report server, then from what I understand you are forced to have your report server databases hosted in a shared location so that all the report servers can connect to and read/write to that location.
As for performance, it depends.
You could host it on your existing database server, but then it will have to compete for resources with the other databases on that server.
Depending on how much slack capacity you have that could cause a problem.
If it does, then you need to find a new location to host your report server databases. You could host it on the single report server itself provided that server has enough processing power and RAM to run the database server and render reports at the same time.
Again... just depends on what your load is going to be.
Not sure if I was really any help here or not 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply