US 11,816,589 B2
Performance throttling identification service for autonomous databases as a service
Meenakshi Sundaram P, Walldorf (DE); Mayank Tiwary, Rourkela (IN); Pritish Mishra, Odisha (IN); and Shashank Mohan Jain, Karnataka (IN)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jan. 16, 2020, as Appl. No. 16/744,502.
Prior Publication US 2021/0224675 A1, Jul. 22, 2021
Int. Cl. G06F 16/21 (2019.01); G06N 3/06 (2006.01); G06N 20/00 (2019.01); G06N 7/01 (2023.01); G06N 5/02 (2023.01)
CPC G06N 7/01 (2023.01) [G06F 16/217 (2019.01); G06N 5/027 (2013.01)] 15 Claims
OG exemplary drawing
 
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.