-
Title
How to measure performance of Export? -
Description
How to measure performance of Export? -
Cause
General information. -
Resolution
Use “show export detail” command in sp_ctrl. Here are some of the salient points in the output generated:
The output is split into 3 paragraphs. The first para covers the stat since the time the current config file was activated. The second covers the stats since the Export process was last stopped and restarted. The last para covers the Export activity after the last time the command was issued. Every time the command is issued, the first and the second para will show the cumulative averages for the Export process since last activation and last bounce (of Export) respectively. For the last para the time window will be created from the time of the previous issuance of the command to the time of the latest issuance of the command. The stats are then generated for this time window.
Here is how the output shows up when the command is issued successively:
sp_ctrl (alvsupu15:5438)> show export detail
Host : alvsupu15
Queue : alvsupu15
Kbytes
Target Status Exported Since Total Backlog
---------- --------------- ------------ ------------------ ---------- ----------
alvsupu07. Running 7061 14-Feb-17 13:47:42 0 0
Since activated
Transmission rate : 13 bytes/sec
Average packet size : 360 bytes
Average send time : 353 microseconds
Since export started
Transmission rate : 13 bytes/sec
Average packet size : 360 bytes
Average send time : 353 microseconds
During the last 379 seconds:
Transmission rate : 18 Kb/sec
Average packet size : 360 bytes
Number of packets : 20000
Average send time : 354 microseconds
Largest deviation from average : 647989 microseconds
Send times deviating by more than %50 : %0.6
sp_ctrl (alvsupu15:5438)> show export detail
Host : alvsupu15
Queue : alvsupu15
Kbytes
Target Status Exported Since Total Backlog
---------- --------------- ------------ ------------------ ---------- ----------
alvsupu07. Running 42423 14-Feb-17 13:47:42 0 0
Since activated
Transmission rate : 83 bytes/sec
Highest transmission rate : 430 Kb/sec Mon Feb 20 14:33:50 207
Average packet size : 361 bytes
Average send time : 670 microseconds
Since export started
Transmission rate : 83 bytes/sec
Highest transmission rate : 430 Kb/sec Mon Feb 20 14:33:50 207
Average packet size : 361 bytes
Average send time : 670 microseconds
During the last 62 seconds:
Transmission rate : 128 Kb/sec
Average packet size : 362 bytes
Number of packets : 22681
Average send time : 460 microseconds
Largest deviation from average : 2038042 microseconds
Send times deviating by more than %50 : %2.4
The headings in the 3rd para “During the last 379 seconds” and “During the last 62 seconds” tells us that the first output is from the command which was issued after 379 seconds of the previous issuance and the second output is from the command which was issued after 62 seconds of the previous issuance. The third para has the lines “Largest deviation from average” and “Send times deviating by more than %50” which may show skewed readings. The first line will show a skewed reading if there is a large batch job executed during the time the command was issued as seen below:
Largest deviation from average : 2038042 microseconds
The second line will show skewed reading if there is very light activity during the period of observation relative to the activity of the regular replication (in our SharePlex instance) as the following shows:
Send times deviating by more than %50 : %800.0 (by the way this output was taken from another session where the replication activity was extremely light)