Show TOC

 Displaying Database Connection StatisticsLocate 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 the workload generated by accesses to databases is distributed across the various database connections.

Procedure
  1. Start the Workload Monitor by calling transaction ST03.
  2. In the Workloadtree, choose the instance and period to be analyzed.
  3. Choose   Analysis Views →   DB Connection Statistics.
  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

Connections

Workload due to accesses to the database, broken down by different database connections. To display the workload broken down by different transactions or reports that used a specific database connection, select that database connection.

Transactions

Workload due to accesses to the database, broken down by different transactions or reports. To display the workload broken down by different database connections used by a transaction, select that transaction.

 Workload Monitor start page