The Details Table provides information about the synchronizations, including phase times. All times are measured by the MobiLink server. Some phase 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 clicking Tools » Options and then opening the Table tab. For information about the statistics that are available, see MobiLink synchronization statistical properties.
The following columns appear by default:
number Identifies each synchronization. This number is assigned by the MobiLink server, not by the MobiLink Profiler, so it does not necessarily start at 1 in any given MobiLink Profiler session and is not necessarily received in numerical order. This number is the same as the synchronization number shown in MobiLink server warnings, errors, and logs. You can see the same number in the Synchronization Properties window. See Synchronization properties.
remote_id The unique identifier of the remote database. See Remote IDs.
user The MobiLink synchronization user. See MobiLink users.
version The version of the synchronization script.
See Script versions.
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.
All the following phase times are in seconds.
sync_request phase 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, in which case 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.
receive_upload phase The time taken from the first bytes of the upload stream being received by the MobiLink server until the upload stream from the remote database has been completely received. The upload stream includes table definitions and the remote database rows being uploaded, so the time may be significant even for a download-only synchronization. The time depends on the size of the upload stream and the network bandwidth for the transfer.
get_db_worker phase The time required to acquire a free database worker thread.
connect phase 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 phase The time for MobiLink to validate the synchronization request, the user name, and 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 phase The time to run your begin_synchronization script, if one was run.
apply_upload phase The time 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 phase The time to run your prepare_for_download script, if one was run.
fetch_download phase The time to fetch the rows to be downloaded from the consolidated database. This is the time between the begin_download script and the end_download script.
end_sync phase The time to run the end_synchronization script, if one was run.
send_download phase The time taken to send the download stream to the remote database.
wait_for_download_ack phase If download acknowledgement is enabled, this includes the time spent waiting for the download to be applied to the remote database and for the remote database to send the download acknowledgement.
get_db_worker_for_download_ack phase If download acknowledgement is enabled, this includes the time spent waiting for a free database worker thread after the download acknowledgement was received.
connect_for_download_ack phase If download acknowledgement is enabled, this includes the time required by the database worker thread to make a database connection if a new database connection is needed.
nonblocking_download_ack phase If download acknowledgement is enabled, this includes the time required for the publication_nonblocking_download_ack connection and nonblocking_download_ack connection events.
To sort the table by a specific column, click the column heading. If new data appears in the MobiLink Profiler, it gets sorted as it is added.
You can close the Details Table pane by clearing Details Table option in the View menu.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|