SSRS on a Secondary Replica
0
votes
1
answer
59
views
We have an availability group database with 4 servers which includes a asynchronous replica that is used for reporting. Sometimes due to large query sets the secondary replica stops synchronization and we have to resume synchronization manually.
We also want to install SSRS on the secondary replica that we use for reporting.
Here are my below questions
1) Is it worth the performance hit to install SSRS on secondary replica as we don't have Enterprise license to install SSRS on a separate host.
2) Can we separate the secondary report server and synchronize data through SSIS hence there will be 3 node availability group database servers and one separate report server which synchronizes through SSIS or some other form .
Overall is it advisable to RUN SSRS on the secondary replica. Thanks for the input
Asked by SQL_NoExpert
(1117 rep)
Sep 17, 2024, 04:27 PM
Last activity: Sep 18, 2024, 03:03 PM
Last activity: Sep 18, 2024, 03:03 PM