Identifying performance issues in SQL statements (PTF BQU1678 applied)
The SQL Analysis app displays the top 100 SQL statements for a subsystem that use the most CPU time. The app defaults to displaying the SQL statements for the last subsystem selected in the app. The SQL Analysis app displays the following views:
- Subsystem summary
- Statement detail
Use the following procedure to view a report of SQL statements with performance issues for a subsystem.
To identify performance issues in SQL statements
New BMC Workbench console
- In the upper left corner of the New BMC Workbench console, click Apps.
- Click SQL Analysis
. - Select the Subsystem you want to investigate.
(optional) Click Filter
to limit the results displayed based on one or more of the following fields:- Plan
- Program
For more information, see Filtering-the-result-set-for-an-SQL-app-PTF-BQU1678-applied.
- (optional) Click Filter Time Interval
to adjust the time period in which you want to view results. For more information, see Selecting-the-time-interval-for-SQL-apps-PTF-BQU1678-applied. - To view the details for a row:
- Select the row and click Details.
- Double-click the row.
- (Optional) To analyze the statement, click the Explain
menu and then select Dynamic.
For more information, see Performance-perspective. - Click
to return to the subsystem summary view. - (Optional) Click
to update the information displayed in the subsystem summary view.
Classic BMC Workbench console
- In the upper right corner of the Classic BMC Workbench console, click Apps.
- Click SQL Analysis
. - Select the Subsystem you want to investigate.
(optional) Click Filter
to limit the results displayed based on one or more of the following fields:- Plan
- Program
For more information, see Filtering-the-result-set-for-an-SQL-app-PTF-BQU1678-applied.
- (optional) Click Filter Time Interval to adjust the time period in which you want to view results. For more information, see Selecting-the-time-interval-for-SQL-apps-PTF-BQU1678-applied.
- To view the details for a row:
- Select the row and click Details.
- Double-click the row.
- (Optional) To analyze the statement, click the Explain menu and then select Dynamic.
- Click to return to the subsystem summary view.
- (Optional) Click to update the information displayed in the subsystem summary view.
Where to go from here
Use the Performance perspective to analyze an SQL statement with poor performance. For more information, see Tuning-SQL.