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

SQL Anywhere 12.0.0 » MobiLink - Server Administration » Using MobiLink server technology » MobiLink Monitor » Using the MobiLink Monitor

 

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 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.