CPC G06N 7/01 (2023.01) [G06F 16/217 (2019.01); G06N 5/027 (2013.01)] | 15 Claims |
8. A computer-implemented method associated with a database tuning as a service offered by a cloud platform as a service provider, comprising:
periodically executing, by a monitoring agent associated with a database service instance running on a client database virtual machine, a performance throttling detection engine;
gathering, by the performance throttling detection engine, database statistics based on metrics and features of the database service using a rule-based approach;
using a probe to determine an amount of data written by a specific process of the database service instance;
predicting an amount of data written to the database service instance using historic workload data;
averaging a time difference between peaks in disk-latency for consecutive peaks;
deciding that an external database tuning service application needs to tune a background writer knob configuration parameter based on the amount of data written, the predicted amount of data, and the averaged time difference; and
when it is decided that a database tuner as a service needs to tune the background knob configuration parameter, transmitting the gathered database statistics to the database tuner as a service.
|