Resource Monitor 
The SQL Performance user menu 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.
Prerequisite
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.
Procedure
...
1. In the user menu, choose Database: Monitoring ® Database Assistant (transaction DB50).
2. Choose Problem Analysis ® SQL Performance ® Resource Monitor.
Possible Functions
· 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.
· 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.
· To display the logged SQL statements, choose Refresh Display.
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 Calling Pos. In ABAP Program.
The system displays a list of costly SQL statements and their execution statistics.