Before you can capture database performance
data for SQL statements that are run from a Java application in the workbench, you must
configure your Java project.
After you capture the performance data, you can import and view the
performance data in the SQL Outline view.
The
application must run the SQL statements on a database that is monitored
by Optim™ Performance
Manager Extended Edition.
Before you begin
Ensure that following requirements are met:
- The Java project must have
pureQuery support enabled to view imported performance data in the SQL
Outline view.
- When you run your application, the classpath must contain the
pureQuery JAR files pdq.jar and pdqmgmt.jar.
- Your database application must run SQL statements dynamically.
- If you are using the pureQuery API in your application, you must
use pureQuery inline methods to run the SQL statements.
- The SQL statements must run on a database that is monitored by Optim Performance
Manager Extended Edition.
- For the installation of Optim Performance
Manager that is monitoring
the database, you must know the URL of the computer and the port used
by Optim Performance
Manager Extended Insight.
About this task
In the pureQuery properties file of your Java project, you set the pdq.cmx.controllerURL
property. The property specifies the computer running Optim Performance
Manager and the port used
by Optim Performance
Manager Extended Edition.
Procedure
To enable database performance monitoring of SQL statements:
- Add the pdq.cmx.controllerURL property
and value to pureQuery runtime properties file for your project. The default name of the properties file is pdq.properties.
The
value of the property in the properties file of your project must
match the value of the property for the Optim Performance
Manager installation that
is monitoring the database.
In the following properties file
example, the value of
pdq.cmx.controllerURL property
is
PERFMON.test.systems:60000:
pdq.captureMode=ON
pdq.executionMode=DYNAMIC
pdq.pureQueryXml=pureQueryFolder/capture.pdqxml
pdq.cmx.controllerURL=PERFMON.test.systems:60000
The
value is the URL of the computer (
PERFMON.test.systems)
and the
Optim Performance
Manager extended
insight port (
60000) for the installation of
Optim Performance
Manager.
- Run the Java application.
Results
When you run your application, it runs as an as an extended
insight client for Optim Performance
Manager.
SQL performance data is captured and stored in the Optim Performance
Manager repository database.
You
can import the performance data and view the data in the SQL
Outline view.
You can view the SQL performance data
that is in the repository database with Optim Performance
Manager. Log on to the Optim Performance
Manager installation that
is monitoring your database. From the Extended Insight Analysis
Dashboard, select your monitored database and view performance
information. The performance data for SQL statements are displayed
as dashboard details.