Time Profile 
Query: 0CCMS_ASR_TIMEDISTR
Use this query to obtain an overview of the distribution of response times depending on the different task types. The query is based on the analysis view of the same name in the Workload Monitor (more information:Displaying Response Time Distribution).
Note
This query is not used in any of the delivered Web templates of the Performance Suite or IT Performance Reporting. It is therefore intended primarily for users with extensive BI knowledge who require templates and usage examples for their own queries in the area of aggregates of ABAP statistical data.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Time Range |
0CCMATIRA |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Dialog Steps |
0CCMACNT |
— |
| Total Response Time (Seconds) |
0CCMARETI |
— |
| Average Response Time / Dialog Step [ms] |
'Total Response Time [s]'/'Number of Dialog Steps' |
|
| Total Processing Time [s] |
0CCMAPRTI |
— |
| Average Processing Time per Dialog Step [ms] |
'Total Processing Time [s]'/'Number of Dialog Steps' |
|
| Total CPU Time [s] |
0CCMACPTI |
— |
| Average CPU time [ms] |
'Total CPU Time [s]' / 'Number of Dialog Steps' |
|
| DB Time [s] |
'Total Time for Direct Reads [s]' + 'Total Time for DB Procedure Accesses [s]' + 'Total Time for Sequential Reads [s]' + 'Total Time for Logical DB Changes [s]' |
|
| Average DB Time per Dialog Step [ms] |
'DB Time [s]' / 'Number of Dialog Steps' |
|
| Total Time for DB Procedures Accesses [s] |
0CCMADPTI |
— |
| Average Time for DB Procedure Call / Step [ms] |
'Total Time for DB Procedures Accesses [s]' / 'Number of Dialog Steps' |
|
| Total Roll-Wait Time [s] |
0CCMARWTI |
— |
| Average Roll-Wait Time per Dialog Step [ms] |
'Total Roll-Wait Time [s]' / 'Number of Dialog Steps' |
|
| Total Wait Time [s] |
0CCMAQETI |
— |
| Average Wait Time per Dialog Step [ms] |
'Total Wait Time [s]' / 'Number of Dialog Steps' |
|
| Share of Response Time that Is Procedures Time [%] |
'Total Processing Time [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Response Time that Is CPU Time [%] |
'Total CPU Time [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Response Time that Is DB Time [%] |
'DB Time [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Response Time that Is DB Procedures Time [%] |
'Total Time for DB Procedures Accesses [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Response Time that Is Roll Wait Time [%] |
'Total Roll Wait Time [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Response Time that Is Wait Time [%] |
'Total Wait Time [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Response Time that Is GUI Time [%] |
'Total GUI Time [s]' / 'Total Response Time [s]' * 100 |
|
| Total Front End Network Time |
0CCMAGNTI |
— |
| Total GUI Time |
0CCMAGUTI |
— |
| Number of Roundtrips |
0CCMAGUCN |
— |
| Average Front End Network Time [ms] |
'Total Front End Network Time [s]' / 'Number of Dialog Steps' |
|
| Average GUI Time per Dialog Step [ms] |
'Total GUI Time [s]' / 'Number of Dialog Steps' |
|
| Average GUI Time per Roundtrip [ms] |
'Total GUI Time [s]' / 'Number of Roundtrips' |
|
| Number of Sequential Reads |
0CCMARSCN |
— |
| Total Sequential Read Time |
0CCMARSTI |
— |
| Average Sequential Read Time [ms] |
'Total Sequential Read Time [s]' / 'Number of Sequential Reads' |
|
| Number of Direct Reads |
0CCMARDCN |
— |
| Total Direct Read Time [s] |
0CCMARDTI |
— |
| Average Direct Read Time [ms] |
'Total Direct Read Time [s]' / 'Number of Direct Reads' |
|
| Number of Logical DB Changes |
0CCMACHCN |
— |
| Total Time for Logical DB Changes [s] |
0CCMACHTI |
— |
| Average Time for Logical DB Changes [ms] |
'Total Time for Logical DB Changes [s]' / 'Number of Logcal DB Changes' |
|
| Number of Logical DB Calls |
'Number of Logical DB Changes' + 'Number of Direct Reads' + 'Number of Sequential Reads' + 'Number of DB Procedures Calls' |
|
| Average Time for Logical DB Call [ms] |
'DB Time [s]' / 'Number of Logical DB Calls' |
|
| Number of Physical DB Read Accesses |
= 0 |
|
| Number of Modified DB Records |
0CCMAPHRC |
— |
| Records Read from the Single Record Buffer |
0CCMARDBF |
— |
| Number of DB Procedure Calls |
0CCMADPCN |
— |
| Average Time for DB Procedure Call [ms] |
'Total Time for DB Procedures Accesses [s]' / 'Number of DB Procedures Calls' |
|
| Number of VMC Calls |
0CCMAVCCN |
— |
| Total VMC CPU Time [ms] |
0CCMAVCTI |
— |
| Time Used in VMC [s] |
0CCMAVETI |
— |
| Average VMC CPU Time [ms] |
'Total VMC CPU Time [ms]' / 'Number of Dialog Steps' |
|
| Average Time Used in VMC [ms] |
'Time Used in VMC [s]' / 'Number of Dialog Steps' |