Start of Content Area

Function documentation Displaying and Deleting Contents of the Workload Collector Database  Locate the document in its SAP Library structure

Use

The data of the workload collector database, which contains the workload data for the system is automatically reorganized and deleted after the set retention periods are exceeded (see Controlling and Monitoring the Generation of Statistics Data). However, if problems occur during the reorganization of the statistics data, you can also display the corresponding content and delete it manually.

Activities

To display or delete the contents of the workload collector database, start the workload monitor (transaction ST03), and ensure that you are in the Expert user mode.

Displaying Contents of the Workload Collector Database

To check the periods, instances, and aggregates for which there is data in the workload collector database, choose the following path in the navigation bar: This graphic is explained in the accompanying text Collector and Performance DB → This graphic is explained in the accompanying text Performance Database → This graphic is explained in the accompanying text Workload Collector Database → This graphic is explained in the accompanying text Contents.

The period type specifies the type of aggregate.

Period Type

Aggregate

D

Daily aggregate

W

Weekly aggregate

M

Monthly aggregate
Deleting Contents of the Workload Collector Database

To delete data from the workload collector database for individual periods, instances, and aggregates, choose the following path in the navigation bar: This graphic is explained in the accompanying text Collector and Performance DB → This graphic is explained in the accompanying text Performance Database → This graphic is explained in the accompanying text Workload Collector Database → This graphic is explained in the accompanying text Contents. Select the desired data and choose This graphic is explained in the accompanying text (Delete).

Deleting Statistics Records in the File System of the Instance

You can also directly delete the unaggregated statistics files in the file system of the individual instances. To do this, choose the following path in the navigation bar: This graphic is explained in the accompanying text Collector and Performance Database → This graphic is explained in the accompanying text Statistics Records & File → This graphic is explained in the accompanying text Delete File, and select the desired instance by double-clicking it. The system asks whether you want to delete the dialog step or the application statistics file.

Note

If the workload collector is running correctly, both files are automatically deleted when they exceed a certain age (by default, two days). You should therefore only delete the corresponding files manually if there are problems when reading and processing the statistics files.

The deletion is performed without aggregation of the data in the workload collector database. After the deletion, this statistics data is also no longer available for detailed analysis.

This graphic is explained in the accompanying text Workload Monitor start page

 

End of Content Area