SQL Server Performance

Two Publishers on One Server...

Discussion in 'Performance Tuning for SQL Server Replication' started by sthompson, Dec 20, 2004.

  1. sthompson New Member

    I'm using merge replication with a Publisher and 26 Subscribers. I have another server that is using merge with another 5 Subscribers. Question...Can I move that Publisher onto the server that currently has the Publisher on it? Will there be confusion in the distribution database as it will be working with two different merge replication "profiles", etc.

    Thanks in advance,
  2. Twan New Member

    Hi there,

    each publishing database can have multiple merge replication publications, and a single server can have multiple publishing databases as well.

    so yes you should be able to move the database from the second server onto the first and configure the publication/subscriptions

  3. satya Moderator

    True, you can support many publishers to one distribution database, but there may be cases where you want to separate logical replication applications into separate databases, for administration purposes. In some cases, there may also be a performance benefit because you may have reduced contention (both writing to and reading from the distribution database).

    The publisher and subscriber can never have the same priority; SQL Server enforces this while adding subscriptions.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page