×

Method to measure stored procedure execution statistics

  • US 7,340,650 B2
  • Filed: 01/14/2003
  • Issued: 03/04/2008
  • Est. Priority Date: 10/30/2002
  • Status: Active Grant
First Claim
Patent Images

1. A method of evaluating the performance of a business or financial software application comprising the steps of:

  • providing a stored procedure to interact with a database;

    executing the stored procedure in a stored procedure execution time;

    querying the database for the stored procedure execution statistics including reads and writes of the database;

    analyzing the stored procedure execution statistics to generate a set of stored procedure execution statistics based on many runs;

    evaluating the analysis by comparison to a set of predicted or previously recorded execution statistics; and

    modifying the stored procedure when the evaluation shows the performance has degraded as compared to the predicted or previously recorded statistics.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×