Allowing a Publisher in SQL Replication to have multiple distributors - by BravehearT1326

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
1
Sign in
to vote
ID 789878 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 6/11/2013 4:30:01 AM
Access Restriction Public

Description

Hi there

Has the SQL team thought about having the ability within Replication so that a publication could be sent to multiple distributors which could then distribute to multiple subscribers rather than having the current 1:1 ratio.

By having 1 distributer per instance with a very large volume of replication taking place (publications) to a large number of subscribers it can cause bottlenecks and blocking at the distributor.

Just keen to hear SQL teams views on this and if it was ever considered.
Sign in to post a comment.
Posted by Microsoft on 1/15/2014 at 3:47 PM
Hi BravehearT1326 ,

given my previous message, I'm archiving this work item for now.
Regards.

Jean-Yves Devant 
Senior Program Manager
Servicing PM of High Availability and Mobile Technologies in SQL Server.
Release PM of Service Packs for SQL Server.
Posted by Microsoft on 1/15/2014 at 3:47 PM
Hi BravehearT1326,

We've looked into this. Although we would like to improve the product this way we will not have the means to do it in a foreseeable future.
That said your feedback is very valuable to us, we keep track of the suggestion.


Best regards
Jean-Yves Devant 
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Program Manager SQL Server Replication, Change Data Capture, Change Tracking