Database Analyzer 
In the Performance user menu (OLTP/liveCache) you can also find the Database Analyzer tool 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.
Prerequisites
OLTP: Prerequisites
liveCache: The user has been assigned a role in accordance with the authorization concept. You can reach the user menu of the user with the authorizations that correspond to his or her role.
The database or the liveCache is in the ONLINE operational state.
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:
Start/stop Database Analyzer
When the SAP system or the 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 liveCache you have the option of setting, via 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, Log Files of the Database Analyzer