Show TOC

 Reorganizing and Monitoring the Monitoring Database MONILocate this document in the navigation structure

Use

Up to SAP NetWeaver 04 (SAP Web AS 6.40), workload data and various other performance data was stored in the monitoring database MONI in the long term. With SAP NetWeaver 7.0 (SAP Web AS 7.00), the workload statistics that are displayed in transaction ST03 are stored in the workload collector database. However, the monitoring database MONI is still used. It contains, among other things, performance data from the following sources:

  • Table call statistics
  • Function code statistics
  • Operating system statistics
  • Buffer statistics
  • SQLR summary

Although this data is not displayed in the workload monitor, you can still set the reorganization of this data in the monitoring database MONI in transaction ST03.

You can determine the retention period of the existing data in MONI. In this way, you limit the size of the table to optimize the performance of the CCMS monitors. The smaller MONI is, the better the performance of the various CCMS monitors is.

Activities

To perform the following functions, start the workload monitor (transaction ST03) and ensure that you are in the Expert user mode.

Setting Retention Periods for the Performance Database

To set the parameters that affect the reorganization of the table MONI, choose the following path in the navigation bar:   Collector and Performance DB →   Performance Database →   Monitoring Database →   Reorganization. The Retention Time for Performance Data screen appears.

This displays settings for Default Statistics Data and Other Statistics Data. The monitoring database is therefore divided into two parts, and the data for each of these is retained for different lengths of time. You can see which data belongs to which group in the respective group boxes.

During a reorganization run, the system deletes all data whose retention time has expired.

Caution

When statistics are deleted through the new retention times used in a reorganization of the monitoring database MONI, these lost statistics cannot be recovered except through the standard techniques for database recovery.

We recommend the following retention periods:

  • Standard Data

    This data is very detailed and requires a great deal of storage space. The retention period should therefore be relatively short. Set a value of at least "2" for all three types of statistics, so that the statistics are retained for two days, two weeks, and two months respectively. However, you should use longer retention periods for small and medium-sized SAP systems and for testing new SAP releases.

  • Other Data

    This data is less detailed than the standard data and requires significantly less storage space. The retention period can therefore be longer than the retention period for the standard data. Use a retention period of 20 days, 20 weeks, and 14 months.

Displaying and Deleting Contents of the Monitoring Database

To obtain an overview of the contents of MONI, choose the following path in the navigation bar:   Collector and Performance DB →   Performance Database →   Monitoring Database →   Contents. The Performance: Contents of Performance Database MONI screen appears.

This shows the rows of the database, where one row is characterized by the following data:

  • Data source (such as type of data and instance)
  • Period  (day, week, or month)
  • Date
    Note

    The table MONI is specially encrypted and cannot be accessed using conventional methods.

To delete data, choose the desired command from the Extras → Delete Data menu.

 Workload Monitor start page