-ppv mlsrv12 option

mlsrv12 -c "connection-string" -ppv period ...

These values can provide insight into the state of the server, and are useful for determining the health and performance of the MobiLink server. For example, one could look at the DB_CONNECTIONS and LONGEST_DB_WAIT values to look for potential problems with the -w option or in the synchronization scripts. The values also provide an easy way to track system wide throughput measures, such as the number of rows uploaded or downloaded per second and the number of successful synchronizations per second.

The suggested period is 60 seconds.

If the period is set too small, the log will grow very quickly.

Each row of output is prefixed with PERIODIC: to aid in searching for and filtering out the values.

The printed values can include the following information:

Printed value	Description
CMD_PROCESSOR_STAGE_LEN	The length of the queue for synchronization work.
CPU_USAGE	The amount of CPU time used by the MobiLink server in microseconds.
DB_CONNECTIONS	The number of database connections in use.
FREE_DISK_SPACE	The disk space available on the temp disk in bytes.
HEARTBEAT_STAGE_LEN	The length of the queue for periodic, non-sync work.
LONGEST_DB_WAIT	The longest length of time an active synchronization has been waiting for the database.
LONGEST_SYNC	The age of the oldest synchronization in microseconds.
MEMORY_USED	The bytes of RAM in use (for Windows only).
ML_NUM_CONNECTED_CLIENTS	The number of connected synchronization clients.
NOTIFIER_STAGE_LEN	The length of the notifier work queue.
NUM_COMMITS	The total number of commits.
NUM_CONNECTED_FILE_XFERS	The number of mlfiletransfers currently connected.
NUM_CONNECTED_LISTENERS	The number of listeners currently connected.
NUM_CONNECTED_MONITORS	The number of monitors currently connected.
NUM_CONNECTED_PINGS	The number of pinging clients currently connected.
NUM_CONNECTED_SYNCS	The number of data synchronizations currently connected.
NUM_ERRORS	The total number of errors.
NUM_FAILED_SYNCS	The total number of failed syncs.
NUM_IN_APPLY_UPLOAD	The number of synchronizations currently in the apply upload phase.
NUM_IN_AUTH_USER	The number of synchronizations currently in the authenticate user phase.
NUM_IN_BEGIN_SYNC	The number of synchronizations currently in the begin synchronization phase.
NUM_IN_CONNECT	The number of synchronizations currently in the connect phase.
NUM_IN_CONNECT_FOR_ACK	The number of synchronizations currently in the connect for download ack phase.
NUM_IN_END_SYNC	The number of synchronizations currently in the end synchronization phase.
NUM_IN_FETCH_DNLD	The number of synchronizations currently in the fetch download phase.
NUM_IN_GET_DB_WORKER_FOR_ACK	The number of synchronizations currently waiting for a database connection to process a non-blocking download acknowledgement.
NUM_IN_NON_BLOCKING_ACK	The number of synchronizations currently in the non-blocking download ack phase.
NUM_IN_PREP_FOR_DNLD	The number of synchronizations currently in the prepare for download phase.
NUM_IN_RECVING_UPLOAD	The number of synchronizations currently in the receive upload phase.
NUM_IN_SEND_DNLD	The number of synchronizations currently in the send download phase.
NUM_IN_SYNC_REQUEST	The number of synchronizations currently in the synchronization request phase.
NUM_IN_WAIT_FOR_DNLD_ACK	The number of synchronizations currently in the wait for download ack phase.
NUM_ROLLBACKS	The total number of rollbacks.
NUM_ROWS_DOWNLOADED	The total number of rows sent to remotes.
NUM_ROWS_UPLOADED	The total number of rows received from remotes.
NUM_SUCCESS_SYNCS	The total number of successful syncs.
NUM_UPLOAD_CONNS_IN_USE	The number of upload connections currently in use.
NUM_WAITING_CONS	The number of synchronizations currently waiting for the consolidated database.
NUM_WARNINGS	The total number of warnings.
OE_STAGE_LEN	The length of the integrated Outbound Enabler work queue.
PAGES_IN_STREAMSTACK	The number of pages held by the network streams.
PAGES_LOCKED	The number of cache pages loaded into memory.
PAGES_LOCKED_MAX	The number of pages in the memory cache.
PAGES_SWAPPED_IN	The total number of pages ever read from disk.
PAGES_SWAPPED_OUT	The total number of pages ever swapped to disk.
PAGES_USED	The number of cache pages used. This includes pages swapped to disk so it may be larger than the cache size.
PRIMARY_IS_KNOWN	Indicates if the primary server is known or not. Shows 0 if the server does not care what the primary server is. Shows 1 if the server knows what the primary server. Shows 2 if the server does not know what the primary server is.
RAW_TCP_STAGE_LEN	The length of the network work queue.
SERVER_IS_PRIMARY	Indicates if the server is primary or secondary. Shows 1 if the server is primary, otherwise shows 0.
SIRT_NUM_LWP_HITS	The number of lightweight polls from remote task agents, indicating a notification.
SIRT_NUM_LWPS	The number of lightweight polls from remote task agents.
SIRT_NUM_REQUESTS	The number of remote task notifications currently outstanding.
STREAM_STAGE_LEN	The length of the high level network processing queue.
TCP_BYTES_READ	The total number of bytes ever read.
TCP_BYTES_WRITTEN	The total number of bytes ever written.
TCP_CONNECTIONS	The number of TCP connections currently opened.
TCP_CONNECTIONS_CLOSED	The total number of connections ever closed.
TCP_CONNECTIONS_OPENED	The total number of connections ever opened.
TCP_CONNECTIONS_REJECTED	The total number of connections ever rejected.
TIMED_WORK_STAGE_LEN	The length of the dynamic caching work queue.
TRACKED_MEMORY	The amount of memory allocated by the server. Use this metric for non-Windows systems where the MEMORY_USED metric is unavailable. On Microsoft Windows systems, use the MEMORY_USED metric for increased accuracy.
VM_MEM_USE	The amount of memory used by any attached VMs.

Below is sample output showing the periodic monitoring values.

I. 2009-10-28 11:46:29. <Main> PERIODIC: TCP_CONNECTIONS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PAGES_USED: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PAGES_LOCKED: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PAGES_LOCKED_MAX: 13243
I. 2009-10-28 11:46:29. <Main> PERIODIC: TCP_CONNECTIONS_OPENED: 2
I. 2009-10-28 11:46:29. <Main> PERIODIC: TCP_CONNECTIONS_CLOSED: 2
I. 2009-10-28 11:46:29. <Main> PERIODIC: TCP_CONNECTIONS_REJECTED: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: TCP_BYTES_READ: 5137
I. 2009-10-28 11:46:29. <Main> PERIODIC: TCP_BYTES_WRITTEN: 4549
I. 2009-10-28 11:46:29. <Main> PERIODIC: ML_NUM_CONNECTED_CLIENTS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PAGES_SWAPPED_OUT: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PAGES_SWAPPED_IN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PAGES_IN_STREAMSTACK: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: CPU_USAGE: 3359375
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_COMMITS: 7
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_ROLLBACKS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_SUCCESS_SYNCS: 1
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_FAILED_SYNCS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_ERRORS: 2
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_WARNINGS: 3
I. 2009-10-28 11:46:29. <Main> PERIODIC: DB_CONNECTIONS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: RAW_TCP_STAGE_LEN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: STREAM_STAGE_LEN: 5
I. 2009-10-28 11:46:29. <Main> PERIODIC: HEARTBEAT_STAGE_LEN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: CMD_PROCESSOR_STAGE_LEN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_ROWS_DOWNLOADED: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_ROWS_UPLOADED: 7
I. 2009-10-28 11:46:29. <Main> PERIODIC: FREE_DISK_SPACE: 124154904576
I. 2009-10-28 11:46:29. <Main> PERIODIC: LONGEST_DB_WAIT: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: LONGEST_SYNC: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: MEMORY_USED: 140275712
I. 2009-10-28 11:46:29. <Main> PERIODIC: SERVER_IS_PRIMARY: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_CONNECTED_SYNCS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_CONNECTED_PINGS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_CONNECTED_FILE_XFERS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_CONNECTED_MONITORS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_CONNECTED_LISTENERS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_WAITING_CONS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_SYNC_REQUEST: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_RECVING_UPLOAD: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_CONNECT: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_AUTH_USER: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_BEGIN_SYNC: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_APPLY_UPLOAD: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_PREP_FOR_DNLD: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_FETCH_DNLD: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_END_SYNC: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_SEND_DNLD: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_WAIT_FOR_DNLD_ACK: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_GET_DB_WORKER_FOR_ACK: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_CONNECT_FOR_ACK: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_IN_NON_BLOCKING_ACK: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NUM_UPLOAD_CONNS_IN_USE: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: TRACKED_MEMORY: 56269577
I. 2009-10-28 11:46:29. <Main> PERIODIC: VM_MEM_USE: 517013504
I. 2009-10-28 11:46:29. <Main> PERIODIC: TIMED_WORK_STAGE_LEN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: NOTIFIER_STAGE_LEN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: SIRT_NUM_REQUESTS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: SIRT_NUM_LWPS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: SIRT_NUM_LWP_HITS: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: OE_STAGE_LEN: 0
I. 2009-10-28 11:46:29. <Main> PERIODIC: PRIMARY_IS_KNOWN: 0

-ppv mlsrv12 option

Syntax

Remarks

Example