Show TOC

Procedure documentationResource Monitor Locate this document in the navigation structure

 

The SQL Performance user menu of the DBA Cockpit contains the SQL resource monitor. By analyzing SQL 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 identify those SQL statements that have a relatively short runtime but cause a considerable database load due to the number of times they are executed. The SQL resource monitor is therefore a monitoring tool that can be used for load analysis of one workday, for example.

Prerequisites

Prerequisites

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

The SQL resource monitor is always started. The tables SYSDATA_ANALYZE and SYSCMD_ANALYZE contain the SQL statements and the statistical details that the SQL resource monitor records when an SQL statement is executed.

Procedure

Open the DBA Cockpit (transaction DBACOCKPIT) and choose   Performance   SQL Performance   Resource Monitor  .

Note Note

For SAP NetWeaver 7.1, this status information is displayed in the Resource Monitor menu, which is different from the menu described below.

End of the note.

Result

Current Monitor Status

The status of the SQL resource monitor is shown in the Current Monitor Status area.

  • Last Update: You can see when the recording was last updated

  • RTE time measurement activated/deactivated: You can see the status of the runtime environment (RTE) time measurement, and change it, if necessary (Deactivate/Activate RTE Time Measurement).

Output Criteria

Since the number of recorded SQL statements can be very large, you can restrict the display by setting output criteria (Data since, Number of Rows Read, and so on).

To output the results in the SQL resource monitor, choose Refresh Monitor Output.

Recorded SQL Statements

The SQL statements that match the desired output criteria are displayed.

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

To obtain more information about an SQL statement, double-click the SQL statement or choose Details. You can see the complete SQL statement in the following view. Additional analyses are possible for SQL statements:

  • Tables/View Information: The Tables/Views/Synonyms display appears.

  • Save as Local File: You can copy the output to the clipboard or print it directly.

  • Display Callpoint in ABAP Program (only for the OLTP database instance that serves as the basis for the current SAP Web AS system)

  • Information about ABAP Callpoint (only for the OLTP database that serves as the basis for the current SAP Web AS system)

To initialize the SQL resource monitor tables SYSDATA_ANALYZE and SYSCMD_ANALYZE, in the SQL resource monitor, choose Reset Counter.

More Information