Show TOC

Analyzing Bottleneck CandidatesLocate this document in the navigation structure

Use

Bottleneck candidates are SQL statements that meet the conditions that you have defined for the SQL performance analysis (see Configuring the SQL Performance Analysis).

Prerequisites

  • 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.

Procedure

To open the Bottleneck Candidate Details tab page and analyze an SQL statement in detail, double click the corresponding row on the Bottleneck Candidates tab page (see Displaying Bottleneck Candidates).

Single Executions

In this section, the individual executions of the selected SQL statement are displayed. Fields whose values match the filter conditions are highlighted in yellow.

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.

To sort the results, click on the respective column header.

You can choose between different display variants (pre-defined column sets).

Display Variant

Description

Default

Most important values

MCOD + LVC

Contains columns that are only available in specific SAP installations

IO Details

Focus on the I/O behavior

Physical Read Details

Focus on the physical reading behavior

Physical Write Details

Focus on the physical writing behavior

Wait Details

Focus on waiting situations

Caller Details

Focus on the calling application

Bridge Details

Contains special counters for bridge scenarios

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 (see SQL Editor).

  • Show table/view definition

    Shows the table/view definition of the selected (view) table (see 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.

For more information, see Displaying the Search Strategies Used by SQL Statements (EXPLAIN).

More Information

SAP Note 819641 Information published on SAP site (FAQ: MaxDB Performance)

Database Administration, Analyzing the Database Performance