SQL Remote User's Guide
SQL Remote Administration
Tuning Message Agent performance
Tuning incoming message polling
By default, a Message Agent running in continuous mode polls one minute after finishing the previous poll, to see whether new messages have arrived. You can configure the polling interval using the -rd option.
The default polling interval from the end of one poll to the start of another is one minute. You can poll more frequently using a value in seconds, as in the following command line:
dbremote -rd 30s
Alternatively, you can poll less frequently, as in the following command line, which polls every five minutes:
dbremote -rd 5
Setting a very small interval may have some detrimental impact on overall system throughput, for the following reasons:
Each poll of the mail server (if you are using e-mail) places a load on your message system. Too-frequent polling may affect your message system and produce no benefits.
If you do not modify the Message Agent patience before it assumes that an out of sequence message is lost, and requests it be sent again, you can flood your system with resend requests.
In general, you should not use a very small polling interval unless you have a specific reason for requiring a very quick response time for messages.
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.