Creating query workloads from Optim Performance Manager

You can use Optim™ Query Workload Tuner to tune SQL statements that you are monitoring in Optim Performance Manager.

Before you begin

Procedure

To create a query workload from SQL statements that you are monitoring in Optim Performance Manager:

  1. On the Extended Insight Analysis Dashboard in Optim Performance Manager, double-click a workload to view details for that workload.
  2. In the SQL Statements section, click Tune All.

Results

The workflow assistant query tuning lists the new query workload on the Manage and Tune Workloads page of the Manage section.

What to do next

Collect EXPLAIN information about the SQL statements that are in the query workload.

Feedback