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. See Adjusting the polling interval to check for new messages.
How much memory is used by the SQL Remote Message Agent (dbremote) for holding messages to be sent. See Adjusting throughput by caching received messages.
How long the SQL Remote 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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|