Automatic query execution plan management and performance stabilization for workloads

An apparatus for managing query execution plans (QEP) for a database workload, the apparatus comprising:

• a storage device storing executable code;
• a processor executing the executable code, the executable code performing the operations of:
• converting a dynamic Structured Query Language (SQL) workload to at least one static database statement of the database workload;
• detecting a binding of a QEP to the at least one static database statement;
• determining a performance difference between an initial set of performance characteristics of the database workload prior to the binding of the QEP and a subsequent set of performance characteristics of the database workload created by the binding of the QEP in response to detecting the binding of the QEP;
• and
• responding to the performance difference in accordance with a monitoring policy.

A computer program product comprising a tangible storage device storing code executable to perform operations for managing query execution plans (QEP) for a database workload, the operations of the computer program product comprising:

• converting a dynamic Structured Query Language (SQL) workload to at least one static database statement of the database workload;
• in response to detecting a binding of a QEP to the at least one static database statement, determining a performance difference between an initial set of performance characteristics of the database workload prior to the binding of the QEP and a subsequent set of performance characteristics of the database workload created by the binding of the QEP;
• and
• responding to the performance difference in accordance with a monitoring policy.

A computer program product comprising a tangible storage device storing code executable to perform operations for managing query execution plans (QEP) for a database workload, the operations of the computer program product comprising:

• converting a dynamic Structured Query Language (SQL) workload to at least one static database statement of the database workload;
• in response to detecting a binding of a QEP to the at least one static database statement, determining a performance difference between an initial set of performance characteristics of the database workload prior to the binding of the QEP and a subsequent set of performance characteristics of the database workload created by the binding of the QEP;
• storing one or more of the initial set of performance characteristics, the subsequent set of performance characteristics, the binding of the QEP, the performance difference, and one or more QEPs of the database workload influenced by the QEP change in a repository;
• and
• responding to the performance difference in accordance with a monitoring policy.