1.3.1 Process Timings

This topic describes the process timings for easy analysis.

The Performance Diagnostic Plugin facilitates the capture of process timings for easy analysis and the timings captured at both Database and Application/Infra level based on the selection of the Trace Value. All the process timings are captured under the table GWTB_DBTIME_LOG.

Figure 1-4 GWTB_DBTIME_LOG Table



For more information on fields, refer to field description table.

Table 1-3 GWTB_DBTIME_LOG Table Description

Field Description
User ID This column displays the User ID of the simulating user facing performance issues.
Function ID This column displays the Function ID used during the simulation of the issue.
Action This column displays the operation for which the performance issue is being faced.
Channel
This column displays the channel via which the operation is carried out.
  • UI - Operation via Screen
  • GW - External System or Gateway
Layer
This column displays the layer at which the transaction timings were captured.
  • Application Timings = Application layer
  • Database Timings = Database Layer
Start Timestamp This column displays the start timing of the operation.
End Timestamp This column displays the end timing of the operation.
Transaction Info This column specifies if the process was successful or failure along with the operation being pre-fixed.
Capturing of process timings happens on a selection of the below trace:
  • Process Timing at Database Level
  • Process Timing at Application Level
  • All