Analyzing SQL Performance Bottlenecks

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.

In the context menu of the database system administrator or the logged-on database user, choose Performance SQL Performance Analysis .
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.
Double-click an SQL statement to analyze it in detail.

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
Area	Description
Single Executions	List of single executions of the SQL statement
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
Parameters	Values of the parameters of the SQL statement (if any)
Explain	Result of the EXPLAIN statement for the selected execution of the SQL statement 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)