Groups | Blog | Home
all groups > sql server replication > august 2006 >

sql server replication : Overhead on Merge Replication


Vikas
8/4/2006 10:09:01 AM
Hi all!

I want to some answers about Merge Replication.

1) What is the maximum numbers of subscribers used in Merge Replication?
(i heard that max. of 600 subscribers are used). If this crosses then what
is the alternate way of syncronizing data between servers.?

Any help is really appreciated.

Paul Ibison
8/4/2006 7:44:51 PM
I've heard of 2000 subscribers
(http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergperf.mspx)
and don't know of the ultimate limit.
Alternative synchronization partners and republishing can be used to cushion
the blow, as modifying the @max_concurrent_merges parameter.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button