Patent ID: 7882104

Claim:
A computer processing system comprising: at least one processor; a database accessible to the at least one processor; a memory coupled to the at least one processor having an application server executed by the at least one processor, the application server processing an access to the database; a performance monitor that reports performance of the computer processing system relative to a result size of the application server processing the access to the database, wherein the result size is selected from the group consisting of: size of data accessed from the database, and size of a generated page; wherein the performance monitor gathers data from a database monitor that monitors the database and from an application server to generate an output data block that shows correlated performance information from the database monitor and the application server about an application resource, wherein the output data block includes a number of SQL operations, a number of fetch operations, a number of rows fetched from the database, a page size of a generated web page, and a time to process the application resource, where the performance monitor gathers data from the application server by selecting entries from an application server log for the application server, and for each selected entry the performance monitor performs the following steps: (1) comparing the entry from the application server log to operation entries in a database monitor; (2) counting the number of operations entries where the time stamp of the database operation entry falls within the time of the selected entry from the application server log; (3) counting the number of operation entries with in the previous step that are fetches; (4) counting the total number of rows fetched for the selected entry from the application server log; and (5) reporting a performance with correlated data entries from the data where the performance is based on the number of operations that are fetches in step (3) and the number of rows fetched for each of the number of operations in step (4) where reporting the performance comprises the steps of: displaying data determined in the previous steps; analyzing the data and highlighting those entries with a high number of rows fetched and a large page size with respect to other entries; wherein the performance monitor is integrated into the application server to generate an output data block that shows information about an application resource including the result size, wherein the output data block includes a number of fetch operations, a number of rows fetched from the database, and time to process the application resource.