| 摘要 |
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. |
