MONITORING PERFORMANCE OF A DATA PROCESSING SYSTEM

• US 20080183683A1
• Filed: 03/31/2008
• Published: 07/31/2008
• Est. Priority Date: 03/17/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Barsness, Eric Lawrence, Santosuosso, John Matthew
• Granted Patent: US 7,882,104 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3466 Performance evaluation by tracing or monitoring
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 2201/815 Virtual middleware or OS functionality using virtual machines to implement generic software techniques for error detection or fault masking G06F11/1484
• CPC Class Codes: G06F 2201/88 Monitoring involving counting

Abstract

An apparatus and program product monitor performance of a computer system via a result size including a result set size of accesses to a database and a page size. Preferred embodiments are directed to a performance monitor that correlates data from existing tools that report data concerning access to the database and the use of system resources. Other embodiments are directed to a performance monitor that is included in an application server associated with the database.

Claims

1. 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.

2-5. -5. (canceled)

6. A program product comprising:

(A) a performance monitor for a computer system that reports performance of the computer processing system relative to a result size of an application server processing an access to a 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; and

(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; and

(B) computer recordable media bearing the performance monitor.

7-12. -12. (canceled)