Here is a sample of the data displayed with 'show export detail'
sp_ctrl> show export detail
Host : spdl02
Queue : spdl02
Kbytes
Target Status Exported Since Total Backlog
---------- --------------- ------------ ------------------ ---------- ----------
spdl02.dev Running 1063 18-Aug-14 17:05:29 1082 0
Since activated
Transmission rate : 5 Kb/sec
Highest transmission rate : 10 Kb/sec Mon Aug 18 14:45:49 2014
Average packet size : 680 bytes
Average send time : 68 microseconds
Since export started
Transmission rate : 4 Kb/sec
Highest transmission rate : 2 Kb/sec Mon Aug 18 17:07:18 2014
Average packet size : 615 bytes
Average send time : 16 microseconds
During the last 27 seconds:
Transmission rate : 25 Kb/sec
Average packet size : 678 bytes
Number of packets : 1081
Average send time : 19 microseconds
Largest deviation from average : 6002 microseconds
Send times deviating by more than %23 : %0.9
Export measures the following data within a timeslice:
o The number of packets sent
o The number of bytes sent
o The time spent in the send system call for one packet
o The total time spent in the send system call
o The longest time spent in the send system call
When the end of the timeslice is reached, the data gathered during the timeslice is rolled up into a set of stats that are maintined for the life of the process. If the transmission rate during the timeslice is greater than the highest transmission rate since the process started, then the rate and the time of the rate is recorded in the process lifetime stats.
The statistics that are gathered during the life of the process are rolled up into stats that are maintained for the process as long as it is a valid process in SharePlex. If the transmission rate during the life of the process is greater than the highest transmission rate since activation, then the rate and the time of the rate is recorded in the since activation stats. The statistics module has provision for the ability to checkpoint a statistic. Both the process-lifetime and the since-activation statistics are checkpointed by export.
The parameter SP_XPT_PCT_DEVIATION provides the measurement used for the reporting of “Send times deviating by more than %xx” where xx is the value of this parameter.
The values displayed above are computed by:
Transmission rate: bytes sent / elasped time
Average packet size: bytes sent / number of packets sent
Average send time: total time spent in the send system call / number of packets sent
Largest deviation from average: longest time spent in the send system call for one packet
Send times deviating by more than x%: the number of times (during the timeslice) that the time spent in the send system call for one packet deviated more than SP_XPT_PCT_DEVIATION from the average time spent in the send system call (since activation) / number of packets sent
