Show TOC

IT Performance Reports: E2E Java DB Performance Locate this document in the navigation structure

Query Query: 0E2EREP_IS_JAVA_DB_PERFORMANCE

 

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:

  • Start of the navigation path Java System Next navigation step Performance Next navigation step DB Performance End of the navigation path

  • Start of the navigation path Database Next navigation step Performance Next navigation step Java End of the navigation path

The query is used in the Web Template 0E2EREP_IS_DB_PERFORMANCE_DAY (Interactive Reports: DB Performance Java - Day).

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Type of Key Figure

0SMD_METY

= SQL STATEMENTS [SQL STATEMENTS]
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Columns

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]