This query is used in interactive reporting in the Technical Monitoring
work center. This report displays the response time per SQL statement ands the number of SQL statements, to give you an overview of the performance and use of the database.
This query is used in the following reports:
The query is used in the Web Template 0E2EREP_IS_DB_PERFORMANCE_DAY
(Interactive Reports: DB Performance Java - Day).
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
| Type of Key Figure | 0SMD_METY | = SQL STATEMENTS [ |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
| SQL Response Time | ‘Key value’ [1KYFNM] = ‘Mean’ [0SMD_MPEH_XPI_CK001] | |
| Number of SQL Statements | ‘Key value’ [1KYFNM] = ‘Number of Values’ [0SMD_COUN] |