Workload from External Systems (Extended) 
Query: 0CCMS_ASR_EXTSYSLOAD
Use this query to obtain an overview of the workload in a system due to actions from other systems. The query is based on the analysis view of the same name in the Workload Monitor (more information:Displaying Workload from External Systems).
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 |
|---|---|---|---|
| Initial System |
0CCMISYS |
— |
| Initial Action |
0CCMIACTI |
— |
| Initial User |
0CCMIUSR |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Dialog Steps |
0CCMACNT |
— |
| Total Response Time [s] |
0CCMARETI |
— |
| Average Response Time / Dialog Step [ms] |
'Total Response Time [s]'/'Number of Dialog Steps' |
|
| Total CPU Time [s] |
0CCMACTPI |
|
| Average CPU time [ms] |
'Total CPU Time [s]' / 'Number of Dialog Steps' |
|
| Total Database Time (Seconds) |
'Total Time for Direct Reads [s]' + 'Total Time for Sequential Reads [s]' + 'Total Time for DB Procedures Accesses [s]' + 'Total Time for Logical DB Changes [s]' |
|
| Average DB Time per Dialog Step [ms] |
'Total Database Time [s]'/'Number of Dialog Steps' |
|
| Number of DB Procedures |
0CCMADPCN |
— |
| Average Time for DB Procedure Call / Step [ms] |
'Total Time for DB Procedures Accesses [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' |
|
| Number of Sequential Reads |
0CCMARSCN |
— |
| Total Sequential Read Time [s] |
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' |
|
| Average Time for Logical DB Call [ms] |
( 'Total Time for Sequential Reads [s]' + 'Total Time for Direct Reads [s]' + 'Total Time for Logical DB Changes [s]') / 'Number of Logical DB Calls' |
|
| Number of Physical DB Read Accesses |
'Number of DB Accesses' - 'Number of Modified DB Records' |
|
| Number of Modified DB Records |
0CCMAPHRC |
— |
| Records Read from the Single Record Buffer |
0CCMARDBF |
— |
| Number of DB Procedures Calls |
0CCMADPCN |
— |
| Total Time for DB Procedures Accesses [s] |
0CCMADPTI |
— |
| Average Time per Database Procedure Call [ms] |
'Total Time for DB Procedures Accesses [s]' / 'Number of Database Procedures Calls' |
|
| Share of Response Time that Is CPU Time (%) |
'Total CPU Time [s]' / 'Total Response Time [s]' * 100 |
|
| Share of Database Time that Is Wait Time (%) |
'Total Database 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 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 [s] |
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' |
|
| Requested Data (KB) |
'SLI_CNT' + 'QUECNT' + 'DSQLCNT' |
|
| Number of DB Access |
0CCMAPHCL |
— |
| DSQLCNT |
0CCMADCN |
— |
| QUECNT |
0CCMAQCNT |
— |
| SLI_CNT |
0CCMASCNT |
— |