Enabling collection of database performance data for Java applications that are run from the workbench

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 the following requirements are met:

About this task

In your Java project, you set the pdq.cmx.controllerURL property in the properties file pdq.properties, The property specifies the computer running Optim Performance Manager and the port used by Optim Performance Manager Extended Edition.

The properties file is also used by pureQuery Runtime if your project is enabled with pureQuery support.

Procedure

To enable database performance monitoring of SQL statements:

  1. If needed, create the text file pdq.properties in the source directory of your project. For a Java project that is using the default source directory src/, create the file src/pdq.properties.

    If your project is enabled with pureQuery support, the file might exist in the source directory.

  2. Add the pdq.cmx.controllerURL property and value to the properties file for your project.

    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.cmx.controllerURL=PERFMON.test.systems:60000
    pdq.captureMode=ON
    pdq.executionMode=DYNAMIC
    pdq.pureQueryXml=dataAccessFolder/capture.pdqxml
    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.

    The other properties in the file are pureQuery Runtime properties.

  3. Run the Java application.

Results

When you run your application, it runs 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.


Feedback