The number of seconds to add to each wait before checking the transaction log for transactions to be replicated after a previous scan yields no such transaction.
5
An integer from 0 to 3600.
The value of the scan_sleep_increment parameter is the number of seconds added to each wait before the Log Reader component checks the transaction log in the primary database for a transaction to be replicated after a previous scan yields no such transaction.
The number of seconds specified by the scan_sleep_increment parameter is added to each wait until the wait time (in seconds) reaches the value specified by the scan_sleep_max parameter.
For optimum Replication Agent performance, the value of the scan_sleep_increment parameter should be balanced with the average number of operations applied to marked objects in the primary database over a period of time. In general, better performance results from reading more operations in the transaction log during each Log Reader scan. In a primary database that is infrequently updated, increasing the value of the scan_sleep_increment parameter may improve overall Replication Agent performance.
If the database is continuously being updated, the value of the scan_sleep_increment parameter is not significant to Replication Agent performance.
