CPU utilization of several SAP/DB2 instances on one host

[Former Member]

Hello,

we have several SAP/DB2 instances on one host (AIX 5.3, DB2 UDB) CI+DB. Only the one SAPOSCOL is running within this host for all instances.

- production server consists of 6 DB2 and R/3 instances

- AIX 5.3

- DB2 8.2

- versions of SAP within server: R/3 4.7, R/3 4.6c, ECC 6.0

- each instance has assigned a dialog app. Server (Win2003)

There is nothing partitioned nor virtualized on these servers.

Is it possible to see workload (SAPOSCOL data) for all instances via one SAPGUI session (e.g. tx OS07n) and not only just one DB and one APPL server?

We would like to determinate a part in a whole host CPU utilization which is taken by each instance.

Any advice?

Thank You.

Best Regards

-jon-

[Former Member]

Hello - Use SAP transaction ST03n (Workload Monitor)

The SAP Workload Monitor (transaction ST03n) display statistical records for entire landscapes and therefore allows you to analyze statistics data for both SAP R/3 and non-SAP R/3 systems. You can use this data to analyze the workload of the monitored components in great detail. The monitor is organized as a one-screen transaction so that its operation is very intuitive, and so that you can query all desired data with only a few mouse clicks.

While statistics records for an SAP R/3 system can only trace actions that are processed by SAP R/3 components, you can use Distributed Statistics Records (DSRs) to trace actions that are processed across the non-SAP R/3 components J2EE (ST03G) Engine, ITS, and BC. This also works across component boundaries. Components that write statistics records send data from the statistics record with their communication with other components (their u201Cpassportu201D), meaning that the originator of an action or a data flow of a business process can be traced even beyond component boundaries.

The DSRs are first stored locally on the relevant component and are transferred to a monitoring system hourly by CCMS agents, where the aggregated statistical data is stored in a performance database and regularly reorganized.

Integration

· The operation of the global workload monitor is largely similar to the operation of the SAP R/3 workload monitor (transaction ST03N), which displays statistical data for the local ABAP system. The Global Workload Monitor actually uses functions of the SAP R/3 Workload Monitor when you analyze the workload of SAP R/3 Systems.

· The Global Workload Monitor displays statistical data aggregated by the collector. You can display raw statistical data (individual records) from SAP R/3 and non-SAP R/3 Systems from complex system landscapes using the functional trace (transaction STATTRACE). The functional trace offers a finer resolution. You can use the functional trace to trace actions that belong to a business process across system boundaries.

The differences between the functional trace and the Global Workload Monitor are explained in the section Difference Between the Functional Trace and the Global Workload Monitor.

Features

You can perform the following analyses, among others, in the Global Workload Monitor:

· How is the workload distributed among the individual service types? (For more information about service types, see Displaying the Workload Overview.)

· What is the workload of individual actions?

· How is the workload distributed over the individual hours of the day?

· Which action steps have the longest response and wait time?

· What workload data is created when calling external components?

· What is the workload of individual users and which actions has a user performed?

· What workload is created in a component on the basis of actions of external components?

· What is the response time distribution for individual service types (required, for example, for Service Level Agreements)?

· What is the availability of the statistical data for the individual components?

The following applies to all of these analyses:

· You can choose the period for which you want to display data between day, week, and month, or specify the Last Minutesu2019 Load as you require.

· You can display data for any component or optionally totaled for all components of a type.