none
Replication Polling interval

    Question

  • I'm using Transactional Replication. May I know how to set the polling interval so that the replication between servers perform as soon as possible after any insert / update from one sql server?

     

    Thanks!

    Wednesday, October 01, 2008 2:06 PM

All replies

  • By default it is 10 seconds for the log reader agent and 1 minute for the distribution agent. This means that if there are no commands in the log or the distribution database, these agents will sleep for the polling interval and then query again.

    Under high load systems the agents will never sleep.

    While you can set both of these to 1 second, you are not guaranteed latencies under 3 seconds as batch updates can take a long time to process, sometimes up to several hours.
    Wednesday, October 01, 2008 2:49 PM
    Moderator
  • I see. Do you know how to set the time so that I can test the performance using different interval for the application?

     

    Thanks,

    Damon

    Thursday, October 02, 2008 1:39 AM
  • Edit your distribution agent job and log reader agent job and add the -PollingInterval parameter with a value of 1. Don't use 0.

    You can also set a profile with a pollinginterval of 1.
    Thursday, October 02, 2008 2:31 PM
    Moderator