Procedure documentationAnalyzing SQL Performance Bottlenecks Locate this document in the navigation structure


Bottlenecks are troublesome SQL statements that the system recorded during SQL monitoring.


  • You are logged on to the database as the database system administrator or as a database user.

  • The database is in the ONLINE operational state.

  • You have started SQL performance monitoring.

    For more information, see Configuring and Starting SQL Performance Monitoring.


Displaying Bottlenecks
  1. In the context menu of the database system administrator or the logged-on database user, choose   Performance   SQL Performance Analysis  .

  2. Enter the number of SQL statements you want to display and choose Get Bottleneck Candidates.

    The Bottleneck Candidates tab page shows two types of SQL statements:

    • Statements whose sum total of all executions meet the requirements a cumulative filter

    • Statements for which a single execution meets the requirements of a single filter.

    Fields whose values match the filter conditions are highlighted.

  3. Double-click an SQL statement to analyze it in detail.

Analyzing Single Executions of an SQL Statement

The Bottleneck Candidate Detail tab page displays the single executions of the selected SQL statement.

Fields whose values match the filter conditions are highlighted in yellow.

Note Note

If no single executions are displayed, this may be due to the following reasons:

  • You did not activate the Detail Collection.

  • None of the single executions match the selected filter conditions.

  • The single executions that matched a filter condition have already been overwritten by newer entries.

End of the note.
Bottleneck Candidate Details



Single Executions

List of single executions of the SQL statement


Text and parameters of the selected execution of the SQL statement

The context menu provides the following functions (selection):

  • Edit

    Opens the SQL editor.

    More information: SQL Editor

  • Show table/view definition

    Shows the table/view definition of the selected (view) table

    More information: Table Editor, View Editor


Values of the parameters of the SQL statement (if any)


Result of the EXPLAIN statement for the selected execution of the SQL statement

Caution Caution

The system does not execute the EXPLAIN statement until you select the entry in the list. In some cases, the system may have used a different execution plan during the actual execution of the SQL statement.

End of the caution.

More information: Analyzing SQL Statements (EXPLAIN)

More Information