Fine-grained virtualization resource provisioning for in-place database scaling

A method, comprising:

• obtaining, at virtualization manager of a multi-tenant host system of a plurality of database instances, wherein each of the plurality of database instances having a respective host management and query engine, respective utilization of one or more computing resources by the plurality of database systems instances on the multi-tenant host system captured within a period of time from respective host management of the plurality of database instances;
• evaluating, by the virtualization manager, the respective utilization of the one or more computing resources, captured within the period of time with respect to a target capacity for one database instance of the plurality of database instances, to detect a scaling event for the one database instance;
• responsive to detecting the scaling event:
• determining, by the virtualization manager based on the respective utilization of the one or more computing resources, a modified target capacity for the one database instance;
• based on the modified target capacity for the one database instance, instructing, by the virtualization manager, the host management of the one database instance to adjust an amount of at least one of the one or more computing resources made available to the multi-tenant host system to use for one or more other database instances of the plurality of database instances at the multi-tenant host system;
• and
• the host management of the one database instance instructing the query engine of the one database instance to perform the adjustment to at least one of the one or more computing resources.

One or more non-transitory, computer-readable storage media, storing program instructions that when executed on or across one or more computing devices cause the one or more computing devices to implement:

• receiving, at a virtualization manager of a multi-tenant host system of a plurality of database instances, wherein each of the plurality of database instances having a respective host management and query engine, respective utilization of one or more computing resources by a plurality of database systems on the multi-tenant host system captured within a period of time from respective host management of the plurality of database instances;
• evaluating, by the virtualization manager, the respective utilization of the one or more computing resources, captured within the period of time with respect to a target capacity for one database instance of the plurality of database instances, to detect a scaling event for the one database instance;
• responsive to detecting the scaling event:
• determining, by the virtualization manager based on the respective utilization of the one or more computing resources, a modified target capacity for the one database instance;
• based on the modified target capacity for the one database instance, instructing, by the virtualization manager, the host management of the one database instance to adjust an amount of the one or more computing resources made available to the multi-tenant host system to use for one or more other database instances of the plurality of database instances at the multi-tenant host;
• and
• the host management of the one database instance instructing the query engine of the one database instance to perform the adjustment to at least one of the one or more computing resources.