Managing Performance Data 

In the Bottleneck or Expert Analysis user menu, 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 liveCache Assistant, it will initially try to read files directly from the database of the current SAP application system.

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

Automatic Transfer

You can transfer the log files automatically.

Choose Automatic Administration.

If you select daily transfer of data from the computer to the DB (table SDBCCMS) from previous day then the performance analysis log files will be copied to the SAP application system database every day, where liveCache is started.

Manual Transfer

You can transfer the log files manually.

Choose Manual Administration.

Enter the required time period for the data transfer from the computer  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 liveCache computer after    days and set the required number of days, the log files will be deleted from the liveCache computer 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 liveCache computer and select delete data to delete log files from the liveCache computer.

·        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.