July 10, 2012 at 12:29 pm
Hello,
I've read the various things on deciding whether to use push or pull replication. Like server load, network connection, etc. I have a particular case to ask about. If you had two identical servers on a local high speed LAN, each serving up a database with equal load. You want each to do transaction replication of that database to the other server. Considering only performance, does push versus pull matter in a case like this?
Thanks for any help,
Kevin
July 10, 2012 at 12:38 pm
I have only seen and experienced performance gains with a pull subscription over a WAN. Have not researched or experienced anything else. We always set ours up as push, but I don't have a reason to say why...
Jared
CE - Microsoft
July 10, 2012 at 12:38 pm
Not in this scenario. Are both servers replicating similar volumes of data/commands?
The real benefit of pull comes when you have a significant number of publications/subscribers. You can chose to spread the load of the distribution agent across the many destinations and leave the distributor to focus on serving up SQL.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply