Automatic query execution plan management and performance stabilization for workloads

摘要

A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.

主权项

1. A method for managing query execution plans (QEP) for a database workload, the method 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.