Show TOC

 Displaying Database Procedure CallsLocate this document in the navigation structure

Use

In the workload monitor, you can display the workload in different Analysis Views, which 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