Analyze SQL performance monitor results

Once you have gathered resources using your performance monitor, you will want to analyze the data that the monitor has collected. If you are using a Summary performance monitor, you will first need to Pause the monitor or End the monitor. A Detailed performance monitor can still be running.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and the database that you want to work with.
  3. Click SQL Performance Monitor.
  4. Right-click on a performance monitor in the right pane, and select Analyze.

After you are done analyzing the results, you can Restart paused monitors, End your monitor. When you use a detailed SQL performance monitor, you can also choose to Run a Visual Explain with the data that you have gathered.

For more information, see Using System i Navigator with detailed monitors in the Database Performance and Query Optimization topic in the Information CenterLink to Information center.