Home Dashboard Directory Help
Search

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


Status: 

Active


1
1
Sign in
to vote
Type: Suggestion
ID: 789878
Opened: 6/11/2013 4:30:01 AM
Access Restriction: Public
0
Workaround(s)
view

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.
Details
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
Sign in to post a workaround.