SQL performance monitor overview

The SQL Performance Monitor allows you to keep track of the resources that SQL statements use. You can monitor specific resources or many resources. The information on resource use can help you determine whether your system and your SQL statements are performing as they should, or whether they need fine tuning. There are two types of monitors that you can choose to monitor your resources. They are:

Summary SQL performance monitor

Detailed SQL performance monitor

Creating a new SQL performance monitor creates a new instance of a monitor on your system. You can have multiple instances of monitors running on you system at one time, however, there can only be one monitor instance monitoring all jobs. When collecting information for all jobs, the monitor will collect on previously started jobs or new jobs started after the monitor is created. However, when you end a performance monitor, the instance of the monitor is terminated and cannot be continued whereas a paused monitor can be restarted.

You need job control authority and read authority to the QUSRSYS schema to use the performance monitor.

For more information, see Database Performance and Query Optimization in the Information Center Link to Information center.