Derek Knutsen (10/25/2016)
But I would also like to put other separate read/write databases on that same instance. Is that possible?ex:
Report_Server
Prod_DB (Read only - replicated from production_server over availability groups)
rept_db (read/write - only exists on this server)
modality_report (read/write - only exists on this server)
SSRS_Summary (read/write - only exists on this server)
Of course it's possible. You have to watch the HW resources to not overload the server.
Igor Micev,My blog: www.igormicev.com