A
system providing precise determination of
resource use within a
software system such as a
database system. A user, such as a
database administrator, operates a
user interface to select and analyze portions of an application for
resource use. In one embodiment in a DB2
database system individual
SQL statement
resource use can be determined. The invention is capable of uniquely identifying even dynamic
SQL statements (i.e., Equalized I.D). Prediction information is presented for when a query, or other database task, will end based on selectable parameters such as optimizer cost, estimated cardinality, and
delta delivery rates of data. A user can create or select event monitors to acquire statistical data on a database task. The results of activating the event monitor are presented to the user such that the user can progressively examine portions of an application,
package, section and even individual statements. The
user interface allows a user to efficiently and precisely identify
processing shortcomings so that the performance of a database task can be improved. The interface also allows a user to sort, or otherwise organize, the statistical data so that analysis of the data is improved and maximum value is derived from the
SQL cost
evaluated data.