I have 3 servers, each with 1 huge database. Let's call them A, B, and C
I'm going to install 3 separate instances of 2017 onto another server - D. Security requirements are what's dictating that it be 3 separate instances instead of 3 db's on 1 instance.
Anyway, I'm going to replicate each of A, B, and C to the corresponding instance on D. I want to do a standalone dedicated distribution server, but I want to have only 1. Will I need 3 different instances - 1 for each distribution db? Or can I get away with 3 distribution databases in 1 instance? Will one scenario perform better than the other?
You can have one distribution database on one instance for all of the publications or you can have multiple distribution databases on one instance. The distribution database takes on a lot of the work and storing transactions so it can become a bottleneck. Which works better really depends on the publications and the activity to be replicated. There is a pretty good article on this site related to some of this - worth reading in your case to see the options:
Scaling Out the Distribution Database
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply