Replication Agent Profile Settings

  • Hi,

    We have large amounts of data replicating one way and i was wondering what the best settings would be for my rep agent to apply the data as quick as possible. The default settings are definitly too slow and we are about 5-6 hours behind. Please help! Thanks.

     

    Dave

  • It sounds like the distribution agent is scheduled and you may need to shorten the period between runs or change to continuous distribution. Continuous distribution would provide the least latency but you need good connections a small number of subscribers. The caveat with continuous is that if the agent fails, you need to restart it manually. A scheduled agent (i.e.  run every 10 minutes) will try again on the next scheduled interval.

     

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

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

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