CPC G06F 16/24545 (2019.01) [G06F 16/217 (2019.01)] | 20 Claims |
1. A computer-implemented method to configure a data warehouse system, comprising:
obtaining, by a configuration management system, historical query workload metadata associated with a data warehouse from the data warehouse system;
determining, based on the historical query workload metadata, a predictive schedule that includes a first configuration setting associated with a configurable parameter for a first time period, wherein the first time period is a future time period, and wherein the first configuration setting is associated with a lower computing resource utilization at the data warehouse system when compared to a previous configuration setting, wherein the configurable parameter is an auto-suspend interval, and wherein determining the first configuration setting for the auto-suspend interval for the first time period comprises:
determining a plurality of time intervals between a time of completion of a first query and a time of arrival of a second query that immediately follows the first query for queries included in the historical query workload metadata; and
setting the first configuration setting to a minimum auto-suspend interval whereby a number of affected queries meets an affected queries threshold, wherein an affected query is a query with an associated time interval that exceeds a corresponding auto-suspend interval;
transmitting, to the data warehouse system, the first configuration setting for the configurable parameter;
receiving, from the data warehouse system, during the first time period, query workload metadata;
determining, based on the query workload metadata, whether the query workload metadata meets a threshold performance; and
based on a determination that the query workload metadata does not meet the threshold performance, transmitting a backoff configuration setting for the configurable parameter to the data warehouse system.
|