Displaying and Deleting Contents of the Workload Collector Database 

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:  Collector and Performance DB →  Performance Database →  Workload Collector Database →  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:  Collector and Performance DB →  Performance Database →  Workload Collector Database →  Contents. Select the desired data and choose  (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:  Collector and Performance Database →  Statistics Records & File →  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.

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.

 Workload Monitor start page