In the Bottlenecks user menu (DBA Cockpit/Database/liveCache Assistant) or Expert Analysis (DBA Cockpit/Database/liveCache Assistant) you can, among other things, transfer the log data of the Database Analyzer into the database, delete log data or aggregate performance data.
Choose
.When accessing log files of the Database Analyzer with the Database/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 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.
You can transfer the log files automatically. To do this, 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.
You can transfer the log files manually. To do this, choose Manual Administration.
Enter the desired time period for the data transfer from the computer to the database (Table SDBCCMS) and choose Transfer Data, to copy the log files into the database.
Ensure that old and superfluous log files are deleted.
You can delete the log files automatically. To do this, 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.
You can delete the log files manually. Choose Manual Administration.
Enter the desired 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 desired time period for deleting performance data from the database (Table SDBCCMS) and then choose Delete Data to delete the log files from the database.
You can aggregate performance data from the Database Analyzer.
You can aggregate the performance data automatically. Choose Automatic Administration.
If you set the marker to Daily Aggregation of Data (Previous Day, Week, Month, Quarter), the data will be aggregated automatically.
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 for the appointed time period.
Enter the required time period for deleting aggregated data and choose Delete Aggregated Data to delete the aggregated performance data for the appointed time period.
Note
Aggregate the data once manually, then set it to automatic aggregation for any subsequent activities.