January 11, 2019 at 4:32 pm
Currently we our Reporting Services environment is
Server A - Reporting Services
Server B - Reporting Services DBs, Datawarehouse DB
We are trying to figure out which of the two options below would be best? We are not able to find documentation.
Option One
Server A - Reporting Services, Reporting Services DBs
Server B - Datawarehouse DB
Option Two
Server A - Reporting Services
Server B - Reporting Services DBs
Server C - DataWarehouse DB
Thanks for your help
m
January 12, 2019 at 9:46 am
Do you anticipate - at any time in the near future - scaling your SSRS environment out to multiple servers to load balance report access and generation? If not - then there is no reason to separate the reporting services databases from the reporting services.
There is also no reason to dedicate a separate machine - and licensing - to host the databases for SSRS. Hosting the databases on a shared instance works - but it can limit your implementation if - for example - you want to utilize Enterprise features for SSRS but the shared instance is running Standard Edition. You still have to license Enterprise for SSRS on the reporting services server...
The only reason to host the databases on a shared instance - is to scale-out your SSRS deployment. This way you can have multiple reporting services web servers behind a load balancer connecting to the databases on the shared instance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 14, 2019 at 12:12 pm
Thank you for your reply. This is very helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply