Monitoring performance of a data processing system
First Claim
Patent Images
1. A computer-implemented method for monitoring performance of a computer system with a performance monitor, the method comprising the steps of:
- (A) gathering data from a database monitor that monitors a database and from an application server to show correlated performance information from the database monitor and the application server about an application resource, where gathering data includes selecting entries from an application server log for the application server, and for each selected entry performing the following steps;
(A1) comparing the entry from the application server log to operation entries in a database monitor;
(A2) 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;
(A3) counting the number of operation entries with in the previous step that are fetches; and
(A4) counting the total number of rows fetched for the selected entry from the application server log; and
(B) 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 (A3) and the number of rows fetched for each of the number of operations in step (A4) where reporting the performance comprises the steps of;
(B1) displaying data determined in the previous steps;
(B2) analyzing the data; and
(B3) highlighting those entries with a high number of rows fetched and a large page size with respect to other entries.
1 Assignment
0 Petitions
Accused Products
Abstract
An apparatus and method for monitoring the performance of a computer system via an 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.
32 Citations
2 Claims
-
1. A computer-implemented method for monitoring performance of a computer system with a performance monitor, the method comprising the steps of:
-
(A) gathering data from a database monitor that monitors a database and from an application server to show correlated performance information from the database monitor and the application server about an application resource, where gathering data includes selecting entries from an application server log for the application server, and for each selected entry performing the following steps; (A1) comparing the entry from the application server log to operation entries in a database monitor; (A2) 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; (A3) counting the number of operation entries with in the previous step that are fetches; and (A4) counting the total number of rows fetched for the selected entry from the application server log; and (B) 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 (A3) and the number of rows fetched for each of the number of operations in step (A4) where reporting the performance comprises the steps of; (B1) displaying data determined in the previous steps; (B2) analyzing the data; and (B3) highlighting those entries with a high number of rows fetched and a large page size with respect to other entries. - View Dependent Claims (2)
-
Specification