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:
How often the Message Agent (dbremote) checks for incoming messages. See Adjusting the polling interval to check for new messages.
How much memory is used by the Message Agent (dbremote) for holding messages to be sent. See Adjusting throughput by caching messages.
How long the Message Agent (dbremote) waits for an out-of-order message to arrive before requesting that the message be resent. See Adjusting the requests to resend messages.
How many worker threads are used to process the received messages. See Adjusting the number of worker threads.
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
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |