Show TOC

SQL PerformanceLocate this document in the navigation structure

Use

In the Performance user menu of the DBA Cockpit, you can find, among other things, tools for checking SQL performance. Use these tools in combination with the analysis of bottlenecks.

Procedure

Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Performance Next navigation step SQL Performance End of the navigation path.

Result

The following tools are available:

  • Command Monitor

    You can perform a short analysis with the command monitor if, for example, users have reported especially long-running transactions.

  • Resource Monitor

    You can use the resource monitor to create an overview of the SQL statements that have used the most resources in a specified period.