Post reply

Multiple subscribers in replication

  • April 10, 2007 at 1:09 pm

    #103337

    Can we have multiple subscribers with same database on same server in replication?Do we have any performance issues with this?

     

    Thanks,

    SR

    Thanks,
    SR

  • April 11, 2007 at 8:10 am

    #699785

    It's possible.  Of course there is definitely some performace penalty you will get with it.  It all depends on how big the databases and what type of replication you have set up.  Small database with snapshot replication not too bad. But big database with heavy transactions and transactional replication can be.  Make sure the server has enough hardware to support.

  • April 11, 2007 at 8:14 am

    #699786

    Thanks for response Bulent.

    Even I taught so but one of my peer argues that it will improve performance if we have 2 subscribers on same server on same database and replicating different sets of tables in transactional replication.

    Thanks,

    SR

    Thanks,
    SR

  • April 11, 2007 at 9:21 am

    #699809

    I would implement another physical distributor with pull subscription set up if you're concerned about the performance.  That way another instance of sql server running on completely different server and pull subcription from the subscriber.

    Good day...

    Bulent

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply