scan_sleep_max

The maximum wait interval between Log Reader transaction log scans.

Default

60

Value

An integer from 1 to 3600.

Comments

  • The value of the scan_sleep_max parameter is the maximum number of seconds that can elapse before the Log Reader component scans the transaction log for a transaction to be replicated, after a previous scan yields no such transaction.

  • For reduced replication latency in an infrequently updated database, use lower number settings for the scan_sleep_max parameter.

  • If the primary database is continuously updated, the value of the scan_sleep_max parameter is not significant to Replication Agent performance.