You define a profile to connect to an Optim™ Performance
Manager repository database
so that you can import performance data for SQL statements that are
run on a database that is monitored by Optim Performance
Manager. After you define
the profile, you can import performance data that is stored in the Optim Performance
Manager repository database.
Before you begin
You must have a connection to the Optim Performance
Manager repository database,
or you must know the connection information to the repository database.
If
you are running SQL statements from the SQL editor and importing performance
data from a repository database, you must also know the Optim Performance
Manager Extended Insight communication
port.
About this task
Optim Performance
Manager Extended Insight monitors
databases and gathers performance data on the SQL statements that
are run on the databases. The profile specifies the connection to
the Optim Performance
Manager repository
database that contains the information gathered from a monitored database.
Procedure
To define an Optim Performance
Manager profile:
- Choose.
- In the Preferences dialog box, expand
the nodes .
- On the Optim Performance Manager Profiles page
, click Add to create a profile.
- Specify the Optim Performance
Manager profile
information. You can select an existing database connection
or click New to create a connection.
- If you select an existing connection, the connection must
be to an Optim Performance
Manager repository
database.
- If you Click New to create a connection
to an Optim Performance
Manager repository
database, the New Connection wizard opens. Create a connection
to the Optim Performance
Manager repository
database with the wizard.
- If you are running SQL statements from the SQL editor and
importing performance data from a repository database, specify the
extended insight port.
Results
You can import SQL performance data from a database that
is monitored by Optim Performance
Manager Extended Edition.
The
workbench displays imported SQL performance data in the following
views:
- In the SQL Outline view, when you import
performance data for the SQL statements that are listed in the view.
- In the Performance Metrics view, when you
run an SQL statement from the SQL Editor and
collect performance metrics.