Managing Performance Data

In the bottle-neck or expert analysis user menus, you can also transfer log files from the Database Analyzer into the database, delete log files or aggregate performance data.

Procedure

Choose Goto ® Managing Performance Data.

Transferring Log Files to the Database

When accessing log files of the Database Analyzer with the Database Assistant, the system will initially try to read files directly from the current SAP application system’s database.

If the log files are not available in the database of the SAP application system, it will then read from the database computer, which can be extremely time-consuming. In order to prevent it reading from the computer, you should ensure that the log files from the database computer in the database of the SAP application system are transferred regularly.

Automatic Transfer

You can transfer the log files automatically.

Choose Automatic Administration.

If you set the marker to daily transfer of data from previous day from the host to the DB (table SDBCCMS) then the performance analysis log files will be copied once a day into the database of the SAP application system from which the Database Assistant was launched.

Manual Transfer

You can transfer the log files manually.

Choose Manual Administration.

Enter the required time period for the data transfer from the host to the database (table SDBCCMS) and then choose transfer data to copy the log files into the database.

Deleting Log Files

Ensure that old and superfluous log files are deleted.

Deleting Automatically

You can delete the log files automatically.

Choose Automatic Administration.

·        If you select delete performance data in the database host after    days and set the required number of days, the log files will be deleted from the database host once the number of days has elapsed.

·        If you select delete performance data in the database (table SDBCCMS) after    weeks and set the required number of weeks, the log files will be deleted from the database once the number of weeks has elapsed.

Deleting Manually

You can delete the log files manually.

Choose Manual Administration.

·        Enter the required time period for deleting performance data (files) from the database host and select delete data to delete log files from the database host.

·        Enter the required time period for deleting performance data from the database (table SDBCCMS) and then choose delete data to delete the log files from the database.

Aggregating Performance Data

You can aggregate performance data from the Database Analyzer.

Aggregating Automatically

You can aggregate the performance data automatically.

Choose Automatic Administration.

If you set the marker to aggregating data daily (previous day, week, month, quarter), then the data will be aggregated automatically.

Aggregating Manually

You can aggregate the performance data manually.

Choose Manual Administration.

·        Enter the required time period for aggregating performance data and choose start aggregating to aggregate performance data at the appointed time period.

·        Enter the required time period for deleting aggregated data and choose delete aggregated data to delete the aggregated performance data at the appointed time period.

Aggregate the data once manually then set it to automatic aggregation for any subsequent activities.