The following is a list of the statistical properties for synchronizations that are available in the MobiLink Profiler. These statistics can be viewed in the New Watch window, the Details Table pane, or the Synchronization Properties window. In Synchronization Properties, the property names do not contain underscores.
For more information about the New Watch window, see Statistic customization.
For more information about the Details Table, see Details Table pane.
For more information about the Synchronization Properties window, see Synchronization properties.
Synchronization statisticsMobiLink statistical properties return the following information for synchronizations:
| Property | Description |
|---|---|
| active | True if the synchronization is in progress. |
| apply_upload phase | Time required for the uploaded data to be applied to the consolidated database. |
| authenticate_user phase | Total time to perform user authentication, including executing the authenticate_* events. |
| begin_sync phase | Total time for the begin_synchronization event. |
| client | The type of MobiLink client and full client version. For example, Dbmlsync 16.0.0.xxxx. |
| completed | True if the synchronization completed successfully. |
| conflicted_updates | Number of update rows that caused conflict. A row is included only when a resolve conflict script was successfully called for it. |
| connect phase | 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. |
| connect_for_download_ack phase | Time required by the database worker thread to make a database connection if a new database connection is needed for a download acknowledgement. |
| connection_retries | Number of times the MobiLink server retried the connection to the consolidated database. |
| download | This property indicates the synchronization included a download command. |
| download_ack | Can be none or non-blocking. |
| download_bytes | Amount of memory used within the MobiLink server to store the download and send to the remote database (before any encryption or compression). |
| download_deleted_rows | Number of row deletions fetched from the consolidated database by the MobiLink server (using download_delete_cursor scripts). |
| download_errors | Number of errors that occurred during the download. |
| download_fetched_rows | Number of rows fetched from the consolidated database by the MobiLink server (using download_cursor scripts). |
| download_filtered_rows | Number of fetched rows that were not downloaded to the MobiLink client because they matched rows that the client uploaded. |
| download_warnings | Number of warnings that occurred during the download. |
| duration | Total time for the synchronization, as measured by the MobiLink server. |
| end_sync phase | Total time for the end_synchronization event. |
| fetch_download phase | Time required to fetch the rows to be downloaded from the consolidated database to create the download stream. |
| get_db_worker phase | Time required to acquire a free database worker thread. |
| get_db_worker_for_download_ack | Time spent waiting for a free database worker thread after the download acknowledgement has been received. |
| has_blocked | True if blocking is detected by the MobiLink server. |
| ignored_deletes | Number of upload delete rows that caused errors while the upload_delete script was invoked, when the handle_error or handle_odbc_error are defined and returned 1000, or when there is no upload_delete script defined for the given table. |
| ignored_inserts | Total number of upload insert rows that were ignored. They were ignored because 1) there is no upload_insert script in normal mode; or 2) errors occurred when the MobiLink server was invoking the corresponding script and the handle_error or handle_odbc_error event returned 1000. |
| ignored_updates | Number of upload update rows that caused conflict but a resolve conflict script was not successfully called or no upload_update script was defined. |
| nonblocking_download_ack phase | Time required for the publication_nonblocking_download_ack connection and nonblocking_download_ack connection events. |
| number | Synchronization number. |
| prepare_for_download phase | Total time for the prepare_for_download event. |
| receive_upload phase | Phase time for receiving the upload. |
| remote_id | Remote ID that uniquely identifies the remote database. |
| send_download phase | Time required to send the download stream to the remote database. The time depends on the size of the download stream and the network bandwidth for the transfer. For an upload-only synchronization, the download stream is simply an upload acknowledgement. |
| server | The MobiLink server name or host:port. |
| start_time | Date-time (in ISO-8601 extended format) for the start of the synchronization. |
| sync_deadlocks | Number of deadlocks in the consolidated database that were detected for the synchronization. |
| sync_errors | Total number of errors that occurred for the synchronization. |
| sync_request phase | 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. |
| sync_tables | Number of client tables that were involved in the synchronization. |
| sync_warnings | Number of warnings that occurred for the synchronization. |
| upload | Indicates the synchronization included an upload command. |
| upload_bytes | Amount of memory used within the MobiLink server to store the upload. This provides a good indication of the impact on server memory of a synchronization. |
| upload_deadlocks | Number of deadlocks in the consolidated database that were detected during the upload. |
| upload_deleted_rows | Number of rows that were successfully deleted from the consolidated database. |
| upload_errors | Number of errors that occurred during the upload. |
| upload_inserted_rows | Number of rows that were successfully inserted in the consolidated database. |
| upload_updated_rows | Number of rows that were successfully updated in the consolidated database. |
| upload_warnings | Number of warnings that occurred during the upload. |
| user | MobiLink user name. |
| version | Name of the synchronization version. |
| wait_for_download_ack | Time spent waiting for the download to be applied to the remote database and for the remote database to send the download acknowledgement. |
 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |