Displaying SQL performance data in the SQL Outline view

The SQL performance data can be either captured from Java applications that you run on the workbench or retrieved from an InfoSphere® Optim™ Performance Manager repository.
To view workbench SQL performance data by running a Java application
Create a Data Access Development Run configuration to run a Java application. You use the SQL Outline view to evaluate data about the speed at which the associated database ran the SQL statements that are in the application. You can also compare current data with previously captured data to determine whether changes that you made to SQL statements improved their performance.
To view SQL performance data that is imported from an InfoSphere Optim Performance Manager repository database
Create an InfoSphere Optim Performance Manager profile to connect to the repository database that contains the performance data for the SQL statements in your project. You specify a time interval for the performance data to import. The SQL Outline view displays the performance data for the SQL statements that are run dynamically.

You can save sets of performance data. After you find out which SQL statements are not performing well, you can view their access plans in Visual Explain. You can also tune them with InfoSphere Optim Query Tuner.

The SQL Outline view can display the following types of SQL performance data:

Workbench SQL performance data
Performance data that is captured when a Java application runs SQL statements in the workbench. The data can be captured by pureQuery Runtime when an SQL statement runs or can be from previously saved locally-captured performance data.
Performance manager data
Performance data that is retrieved from an InfoSphere Optim Performance Manager repository.

When you import the InfoSphere Optim Performance Manager data, performance data is only visible for SQL statements that are listed in the SQL Outline view. If the imported data is related to SQL statements that are not listed in the SQL Outline view, that data is not displayed.

In the SQL Outline view, you can view only one type of performance data at a time. In the view, the workbench performance data is displayed slightly differently than the performance manager data.
In the Database page
If workbench SQL performance data is displayed, data is displayed on the row that lists the SQL statement and on the row that lists the SQL statement with program source code line number.

If InfoSphere Optim Performance Manager performance data is displayed, the data is displayed on the row that lists the SQL statement without a line number. The imported data does not contain the information to match the performance data to a SQL statement at specific a location in the file. The rows with the line numbers are grouped with the statement to show locations of the SQL statement in the source code. If the SQL statement is listed more than once, the same performance information is displayed for each occurrence of the statement.

In the Java page
If workbench SQL performance data is displayed, the performance data is displayed on the row that lists a specific SQL statement and source code line number for a Java file.

If the InfoSphere Optim Performance Manager performance data is displayed, the performance data is displayed for the SQL statement in the Java file without a line number. The imported data does not contain the information to match the performance data to a SQL statement at specific a location in the file. The rows with the line numbers are grouped with the statement to show the locations of the SQL statement in the file. If an SQL statement appears in more than one Java file, the same performance information is displayed for each occurrence of the statement.


Feedback