The Processing Rate Graph displays the rate at which the active data transformation is progressing. It is designed similar to the Windows Performance Monitor tool, as it indicates the processing performance. The Counters displayed here are also available in the Windows Performance Monitor for detailed analysis.
The graph moves from right to left. It shows the information of the transactions processed in the past one minute, with the data taken every two seconds by default (Sampling Interval). The Sampling Interval can be configured to a different value.
The X-axis represents Time (in seconds). It indicates 60 seconds in 12 seconds intervals; 0 means “now”. The Y-axis represents the value of the selected counter. This value depends on the scale of that counter. You can select the counter and view its scale in the Legend provided below the graph.
Average, Minimum, and Maximum display the statistics of the selected counter for the past one minute.
The Legend displays the counters available for the active transformations. You can include or exclude the counter by selecting or clearing the corresponding check box. You can identify a counter in the graph by the color in the Legend. The color of the selected counter is highlighted in the graph.
Each row in the Legend includes the following information:
Scale: The scale that is used to calculate the Y-axis value. The scale value is calculated dynamically by the Data Exchange Runtime, depending on the actual counter value. The purpose is to be able to read the calculated value easily and fit it in the Y-axis range.
To get the Y-axis reading you must multiply the actual counter value with the current scale value of this counter. If the scale is 1, then the Y-axis value is the actual value. The scaling factor is 10, so the scale value can be 1, 10, 100... or 0.1, 0.01, 0.001.
For example, assuming the counter may have values ranging between 6 and 2400, then when the value is 6, Data Exchange uses the scale 10 to get a reading of 60. Data Exchange does not use scale 1 because the value 6 would be difficult to read on a Y-axis with 20 as the unit. When the counter value is 2400, Data Exchange changes the scale to 0.01 to get a reading of 24.
Object: The name of the transformation target or source.
Counter:
No. of Transactions Processed: The number of transactions committed to the transformation target or the number of transactions processed from the source database.
No. of Records Processed: The number of records processed in the transformation source. This is available only for bulk data transformations.
No. of Record Updates Committed: The number of SQL commands committed to the transformation target. In case of a transformation from SQL Server to Enterprise Database Server, this is the number of Enterprise Database Server commands committed to the transformation target.
The Processing Rate graph also displays the following information:
Sampling Interval: It is the frequency at which the data is updated. It can be any value between one and five seconds. The default value is two seconds. The shape of the graph changes according to the sampling interval time.
Average: It is the average value of the selected counter.
For example, if the counter selected is No. of Transactions Processed, then Average displays the average value of the number of transactions that have been committed to the transformation target in the past 60 seconds.
Minimum: It is the minimum value of the selected counter.
Maximum: It is the maximum value of the selected counter.