Details Table pane

The Details Table provides information about the duration of each part of the synchronization. All times are measured by the MobiLink server. Some times may be non-zero even when you do not have the corresponding script defined.

You can choose the columns that appear in the Details Table pane by opening Tools » Options and then opening the Table tab. For a description of the statistics that are available, see MobiLink statistical properties.

The following columns appear by default:

  • sync   Identifies each synchronization. This ID is assigned by the MobiLink server, and not by the MobiLink Monitor, so it does not necessarily start at 1 in any given MobiLink Monitor session and is not received in numerical order. You can see the same IDs in the Synchronization Properties window. See Synchronization properties.

  • remote_id   The ID of the remote database.

  • user   The synchronization user.

  • version   The version of the synchronization script.

    See Script versions.

  • download_ack   The type of download ack, which can be none, blocking or non-blocking.

  • start_time   The date and time when the MobiLink server started the synchronization. (This may be later than when the synchronization was requested by the client.)

  • duration   The total duration of the synchronization, in seconds.

  • sync_request   The time in seconds for MobiLink to receive the uploaded data from the client. This is the portion of the synchronization starting at the connection from the remote and ending just before authentication.

  • receive_upload   The time taken between creating the network connection between the remote database and the MobiLink server, up to receiving the first bytes of the upload stream. This time is insignificant unless you have set -sm to a smaller value than -nc, then this time can include the time that a synchronization is paused when the number of synchronizations is larger than the maximum number of active synchronizations that were specified with -sm.

  • get_db_worker   The time required to acquire a free database worker thread.

  • connect   The time required by the database worker thread to make a database connection if a new database connection is needed. For example, after an error or if the script version has changed.

  • authenticate_user   The time in seconds for MobiLink to validate the synchronization request, validate the user name, and validate the password (if your synchronization setup requires authentication). This is the length of the authenticate user transaction (from the start of authentication to just before the begin_synchronization event).

  • begin_sync   The time in seconds to run your begin_synchronization script, if one was run.

  • apply_upload   The time in seconds to apply the upload to the consolidated database. This is the time between the begin_upload script and the end_upload script.

  • prepare_for_download   The time in seconds to run your prepare_for_download script, if one was run.

  • fetch_download   The time in seconds to download the data. This is the time between the begin_download script and the end_download script. If download acknowledgement is enabled, this includes the time to apply the download on the remote database and return acknowledgement.

  • end_sync   The time in seconds to run the end_synchronization script, if one was run.

To sort the table by a specific column, click the column heading. If new data is appearing in the MobiLink Monitor, it gets sorted as it is added.

You can close the Details Table pane by clearing Details Table option in the View menu.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1