Displaying Database Procedure Calls 

Use

In the workload monitor, you can display the workload in different analysis views that highlight the workload from a particular perspective. One of these aspects is the question of how much load is generated due to calls of database procedures.

Procedure

...

       1.      Start the Workload Monitor by calling transaction ST03.

       2.      In the Workload tree, choose the instance and period to be analyzed.

       3.      Choose  Analysis Views →  DB Procedure Calls.

       4.      The system displays the usual output area, in which the requested workload is displayed.

Result

The output area contains two tab pages with the following characteristics:

Tab Page	Meaning
DB Procedure	Workload due to database procedure calls, broken down by the different database procedures. To display the workload broken down by different transactions or reports that called a specific procedure, select that procedure.
Transactions	Workload due to database procedure calls, broken down by the different transactions or reports. To display the workload broken down by different database procedures that were called by a specific transaction, select that transaction.

 Workload Monitor start page