Displaying the average length of time taken to replicate transactions
Use the End-to-End Latency window to display an approximate value for the average length of time used to replicate transactions in a particular subscription set.
From the End-to-End Latency window, for example, you can view the approximate latency for a subscription set for each Apply cycle during a period of time. You can also divide the time period into intervals and display the average latency for each interval.
The Replication Center uses the following formula to calculate the end-to-end
latency:
(ENDTIME - LASTRUN) + (SOURCE_CONN_TIME - SYNCHTIME)- ENDTIME is the time at which the Apply program finishes processing the subscription set.
- LASTRUN is the time at which the Apply program starts processing a subscription set.
- SOURCE_CONN_TIME is the time at which the Apply program connects to the Capture control server to fetch data.
- SYNCHTIME is the time of the most current commit of data to the CD tables by the Capture program.
| Parameter | Column value |
|---|---|
| ENDTIME | 2006–10–20–10:01:00 |
| LASTRUN | 2006–10–20–10:00:30 |
| SOURCE_CONN_TIME | 2006–10–20–10:00:32 |
| SYNCHTIME | 2006–10–20–10:00:00 |
For example, assume a particular subscription set has the values that are
shown in Table 1. Using
the previous equation, the average end-to-end latency for this subscription
set is 62 seconds:
(10:01:00 - 10:00:30) + (10:00:32 - 10:00:00) = 62