Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Managing SQL Remote systems » SQL Remote performance


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:

  • How often the SQL Remote Message Agent (dbremote) checks for incoming messages.

  • How much memory is used by the SQL Remote Message Agent (dbremote) for holding messages to be sent.

  • How long the SQL Remote Message Agent (dbremote) waits for an out-of-order message to arrive before requesting that the message be re-sent.

  • How many worker threads are used to process the received messages.

 See also

Polling interval adjustments to check for new messages
Throughput adjustments by caching received messages
Request adjustments to resend messages
Adjusting the number of worker threads