×

System and method for SQL performance assurance services

  • US 8,930,918 B2
  • Filed: 05/18/2011
  • Issued: 01/06/2015
  • Est. Priority Date: 05/18/2010
  • Status: Active Grant
First Claim
Patent Images

1. A system for assuring performance of a plurality of structure query language (SQL) statements, the system comprising:

  • a memory comprising instructions;

    a processor coupled to the memory, where the processor is configure to execute the instructions to perform a method comprising;

    capturing a volume baseline from a production database, wherein the volume baseline indicates a plurality of production database statistics;

    retrieving an empty schema of the production database;

    creating an emulated environment based on the production database statistics and the empty schema, wherein the emulated environment is created for testing the performance of each of the plurality of SQL statements to be executed in the production database;

    executing the plurality of SQL statements in the emulated environment to forecast an execution time required by each of the plurality of SQL statements in the production database, wherein the execution time is forecasted using a formula; and

    optimizing an execution plan of at least one of the plurality SQL statements by tuning the at least one of the plurality of SQL statements, wherein the at least one of the plurality of SQL statements is tuned based on the execution time thereby assuring the performance of each of the plurality of SQL statements.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×