Resource Monitor

The SQL Performance menu (OLTP/ liveCache) contains, among other things, the resource monitor tool.

By analyzing the resource consumption, you can identify the most costly SQL statements. The resources used by an SQL statement are measured (runtime and I/O accesses, for example).

If an SQL statement is used more than once, the total cost is calculated. This enables you to recognize those SQL statements that have a relatively short runtime, but that generate a considerable database load due to the number of times they are executed.

The resource monitor is therefore a monitoring tool that can be used for load analysis of one workday, for example.

Prerequisites

OLTP: Prerequisites

Only for the OLTP database instance that is the basis of the current SAP Web AS system: so that the name of the ABAP program and other information can be sent to the database instance, the instance profile parameter dbs/ada/register_appl_info=1 must be set.

liveCache: The user has been assigned a role in accordance with the authorization concept.
You are in the user menu of the user with the authorizations that correspond to this role.

Procedure

OLTP: In the Database Assistant, choose Problem Analysis ® SQL Performance ® Resource Monitor.

liveCache: In the liveCache Assistant, choose liveCache ® Monitoring ® Problem Analysis ® SQL Performance ®Resource Monitor.

...

Starting/Stopping the Resource Monitor

To activate or deactivate the resource monitor, choose Resource Monitor ® Start Recording / Stop Recording.

During normal operation of the database system, the resource monitor is deactivated.

Changing a Filter

To change the filter, choose Resource Monitor ® Change Restrictions.

Since the amount of recorded SQL statements can be very large, you can restrict the display by setting filter conditions.

Displaying SQL Statements

?     To display the logged SQL statements, choose Refresh Display in the resource monitor.

?     If a logged SQL statement was called from an ABAP program, you can trace the statement back to this program. To do this, select the statement and choose Call Points in ABAP Program (only for the OLTP database instance that is the basis of the current SAP Web AS system).

?     To obtain additional information about an SQL statement, double-click the statement. You can see the complete SQL statement in the following view.
Further analyses for SQL statements:

Print version: You can copy the output to a clipboard or print it directly.

- Tables/View Information. The Tables/Views/Synonyms display appears.

Display Call Point in ABAP Program (only for the OLTP database instance
    that is the basis of the current Web AS system)

- Information about the ABAP Call Point (only for the OLTP database instance
   that is the basis of the current Web AS system)

Initializing the Resource Monitor Tables

The SQL statements and the values specified in their WHERE clauses are entered in the tables SYSDATA_ANALYZE and SYSCMD_ANALYZE, if these statements meet the recording criteria, and are executed in the database system after the resource monitor was started. These tables are overwritten cyclically. Stopping the resource monitor does not initialize the tables SYSDATA_ANALYZE and SYSCMD_ANALYZE.

To initialize the resource monitor tables, choose Resource Monitor ® Initialize Monitor Tables.

See also:

Concepts of the Database System, Special Database Parameters