Post reply

Replication

  • May 4, 2007 at 6:29 am

    #153567

    guys,

    I have database with in the intranet which I have to sync up in the night with the prod database. I have been

    trying to use replicatiion - subscriber and publisher model but it would slow down the subscriber drastically.

    Is it because replication agent is polling constantly ?

    Is there any better way to accomplish this goal using replication, can you guys point to any resources.

    any comments/suggestions are appreciated.

    Thanks

  • May 4, 2007 at 7:00 am

    #704318

    What type of replication have you been using merge or transactional ?

    Where is the distributor running? On the publisher, the subscriber or a third server ?

    I find it a bit surprising that your subscriber is suffering, usually I would expect a higher impact on the publisher and the distributor.

    Also if you sync only once a day, how many changes need to be synchronied on average per day?

    Markus

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

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