Analysis of performance data from a relational database system for applications using stored procedures or sql

Abstract

Analyzing performance data from a relational database to discover poorly performing SQL statements includes creating event records of performance data for query statements executed by a relational database management system, and condensing the performance data in the event records. A performance summary can be generated for each condensed event record. The performance summaries can then be analyzed based on performance characteristics to identify poorly performing SQL statements.

1 . An system for analyzing performance data comprising:
 means for receiving event records of performance data for query statements executed by a relational database management system; and   means for condensing the performance data in the event records.   
   
   
       2 . The system of  claim 1  further comprising means for generating, from each condensed event record, a performance summary for the executed statement. 
   
   
       3 . The system of  claim 1  further comprising means for analyzing the performance summaries for the executed statements based on one or more performance characteristics to identify one or more statements. 
   
   
       4 . The system of  claim 1  further comprising means for linking each performance summary to the text of the corresponding query statement executed by the relational database management system. 
   
   
       5 . The system of  claim 1  further comprising:
 means for identifying a set of performance summaries for query statements issued by the application program for each application program that issued query statements to the relational database management system; and   means for generating a performance summary for the application program from the corresponding identified set of query statement performance summaries.   
   
   
       6 . The system of  claim 1  further comprising means for analyzing the application program performance summaries to identify one or more application programs. 
   
   
       7 . The system of  claim 1  further comprising means for analyzing the performance summaries for the query statements issued by the application program to identify one or more query statements issued by the application program. 
   
   
       8 . The system of  claim 1  further comprising means for analyzing the application programs and the query statements to improve their performance. 
   
   
       9 . A computer-readable storage medium storing program instructions, the program instructions which when executed by a computer system cause the computer system to execute a method comprising:
 receiving event records of performance data for query statements executed by a relational database management system; and   condensing the performance data in the event records.   
   
   
       10 . The computer-readable storage medium of  claim 9  further comprising program instructions for generating, from each condensed event record, a performance summary for the executed statement. 
   
   
       11 . The computer-readable storage medium of  claim 9  further comprising program instructions for analyzing the performance summaries for the executed statements based on one or more performance characteristics to identify one or more statements. 
   
   
       12 . The computer-readable storage medium of  claim 9  further comprising program instructions for linking each performance summary to the text of the corresponding query statement executed by the relational database management system. 
   
   
       13 . The computer-readable storage medium of  claim 9  further comprising program instructions for:
 for each application program that issued query statements to the relational database management system, identifying a set of performance summaries for query statements issued by the application program; and   generating a performance summary for the application program from the corresponding identified set of query statement performance summaries.   
   
   
       14 . The computer-readable storage medium of  claim 9  further comprising program instructions for analyzing the application program performance summaries to identify one or more application programs. 
   
   
       15 . The computer-readable storage medium of  claim 9  further comprising program instructions for, for each application program, analyzing the performance summaries for the query statements issued by the application program to identify one or more query statements issued by the application program. 
   
   
       16 . The computer-readable storage medium of  claim 9  further comprising program instructions for analyzing the application programs and the query statements to improve their performance.