SAP SE
Automated Plan Upgrade System for Backing Services

Abstract:

Embodiments allow automated provisioning of a plan upgrade for databases hosted in storage environments. A database is hosted in a shared storage environment according an existing plan, based upon consumption of available system resources (e.g., processing, I/O, memory, disk). An agent periodically issues requests for information relevant to database behavior (e.g., performance metrics, query logs, and/or knob settings). The agent collects the received information (e.g., via a domain socket), performing analysis thereon to predict whether future database activity is expected remain within the existing plan. Such analysis can include but is not limited to compiling statistics, and calculating values such as entropy, information divergence, and/or adjusted settings for database knobs. Based upon this analysis, the agent communicates a recommendation including a plan update and supporting statistics. Embodiments can reduce the effort/cost of the database administrator in having to manually predict future estimated database resource consumption and generate a plan update.