Improving performance when receiving messages

The major bottleneck for total throughput in a SQL Remote system is generally receiving messages from many remote databases and applying them to the database. To reduce this lag time, when running a Message Agent (dbremote) in continuous mode, you can adjust the following variables:


Adjusting the polling interval to check for new messages
Adjusting throughput by caching messages
Adjusting the requests to resend messages
Adjusting the number of worker threads