In the Problem Analysis user menu, you can find, among other things, tools for checking SQL performance. Use these tools in combination with the analysis of bottlenecks.
Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose .
The following tools are available:
You can perform a short analysis with the command monitor if, for example, users have reported especially long-running transactions.
You can use the resource monitor to create an overview of the SQL statements that have used the most resources in a specified period.