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 SQL Remote 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 received messages
Adjusting the requests to resend messages
Adjusting the number of worker threads