SQL Remote User's Guide
SQL Remote Administration
Tuning Message Agent performance
Tuning the message sending process
You control the interval to wait between polls for more data from the transaction log to send using the -sd option, which has a default of one minute. The following example sets the polling interval to 30 seconds:
dbremote -sd 30s ...
Alternatively, you can poll less frequently, as in the following command line, which polls every five minutes:
dbremote -sd 5
Setting a very small interval may have some detrimental impact on overall system throughput, for the following reasons:
Too-frequent polling produces many short messages. If the message load places a strain on your message system, throughput could be affected.
Setting larger intervals may provide a better overall throughput of messages in your system, at the cost of waiting somewhat longer for each message to be applied. In many SQL Remote installations, optimizing turnaround time is not the primary concern.