The number of seconds to add to each wait interval before scanning the transaction log, after a previous scan yields no transaction to be replicated.
5
An integer from 0 to 3600.
The value of the scan_sleep_increment parameter is the number of seconds added to each wait interval before the Log Reader component scans the log device 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 interval, until the wait interval 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 in the primary database over a period of time. In general, better performance results from reading more operations from the transaction log during each Log Reader scan.
With a primary database that is less frequently updated, increasing the value of the scan_sleep_increment parameter may improve overall performance.
If the database is continuously updated, the value of the scan_sleep_increment parameter may not be significant to Replication Agent performance.
