Importance

Loading Importance Indicators...

Abstract

The invention is a method to obtain actual stored procedure execution statistics while an overlying application is running. The method is accomplished by a software module running in background and acquires the execution statistics, including database writes and reads, for every stored procedure run. Statistics, such as the number of database writes and reads, are reported by the application's underlying database supervisory program. The resulting execution statistics are analyzed and selected information is saved to a stored procedure statistics database. Because the module can be run continuously in background, it can develop statistics for all procedure calls made under varying computing conditions with varying calling parameter sets. A statistical analysis of such acquired stored procedure execution statistics is useful for evaluating new versions of the complex software application, new stored procedures, modified stored procedures, and for locating a specific cause of application failure or reduced performance as caused by a malformed or malfunctioning stored procedure. Additionally, the method can flag anomalous performance, warning of previously undetected failure.

Loading the Abstract Image...

First Claim