Database Analyzer 
In the Performance user menu you can also find the tool Database Analyzer for bottleneck analysis. When the SAP system is started, the Database Analyzer starts to collect data. The Database Analyzer generates log files that are saved to the respective database server.
Procedure
Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose 
Problem Analysis 
Performance Database Analyzer 
.
or
Open the DBA Cockpit (transaction DBACOCKPIT) and select Performance Database Analyzer .
Result
The following performance analysis options are available:
Starting/Stopping the Database Analyzer
When the SAP system or the SAP liveCache starts up, the Database Analyzer is automatically started for the system's Basis database. With other systems, you need to explicitly start the Database Analyzer. The Database Analyzer must always be activated. The default collection interval for the performance data is 900 seconds.
If necessary, you can start or stop the Database Analyzer explicitly with the Bottlenecks user menu.
For SAP liveCache you have the option of setting, with Automatic Monitoring, whether the Database Analyzer should always be activated or not.
More Information
Database/liveCache Alert Monitor, Database Analyzer
Database Analyzer documentation
Database Analyzer, Database Analyzer Log Files