Generic autonomous database tuning as a service for managing backing services in cloud

Patent metadata

Field	Value
Publication number	US-11157471-B2
Application number	US-201916351737-A
Country	US
Kind code	B2
Filing date	Mar 13, 2019
Priority date	Mar 13, 2019
Publication date	Oct 26, 2021
Grant date	Oct 26, 2021

Abstract

A system and method are disclosed to facilitate a database tuning as a service offered by a cloud platform as a service provider. A throttling detection engine, associated with a database service instance, may periodically determine if an automated database tuning process should be performed. When it is determined that the automated database tuning process should be performed, the throttling detection engine may transmit database performance metrics. A database tuner as a service, coupled to the throttling detection engine, may access aggregated database performance metrics of the database service instance and determine a set of tunable parameters associated with the database service instance. The database tuner as a service may then execute the automated database tuning process to recommend, using an intelligent algorithm, a new set of configurations for the set of tunable parameters to be applied to the database service instance.

First claim

The invention claimed is:

1. A system to facilitate a database tuning as a service offered by a cloud platform as a service provider, comprising:
a storage device storing processor-executable instructions to implement a throttling detection engine associated with a database service instance and to implement a database tuner as a service, coupled to the throttling detection engine; and
a processor to execute the processor-executable instructions, the processor to execute the processor-executable instructions to cause the throttling detection engine to:
periodically determine, based on an actual current performance throttling of the database service instance, whether an automated database tuning process should be performed, and
in response to the determination that the automated database tuning process should be performed, transmit database performance metrics; and

the processor, in response to the determination that the automated database tuning process should be performed, to execute the processor-executable instructions to cause the database tuner as a service to:
access aggregated database performance metrics of the database service instance,
determine a set of tunable parameters associated with the database service instance,

execute the automated database tuning process to recommend, using an intelligent algorithm, a new set of configurations for the set of tunable parameters to be applied to the database service instance; and
validate the recommended new set of configurations for the set of tunable parameters, the validation being based on (1) dynamic rule-based filtering validated against a pre-defined set of rules defined for the specific database service instance and (2) bare service-replica filtering of the database service instance excluding data of the database service instance.

2. The system of claim 1 , wherein the automated database tuning process uses a generic regression process on previously observed database workloads to make said recommendation.

3. The system of claim 1 , wherein the aggregated database performance metrics are associated with a dynamically calculated observation time.

4. The system of claim 1 , wherein the database performance metrics include at least one of: (i) a response time, (ii) a number of queued requests, and (iii) a throughput.

5. The system of claim 1 , wherein the set of tunable parameters includes at least one of: (i) memory knobs, (ii) background writer knobs, (iii) asynchronous and planner estimate knobs, (iv) locking knobs, and (v) any other relevant knob.

6. The system of claim 1 , wherein the validation of the new set of configurations for the set of tunable parameters is evaluated by a recommendation and validation engine.

7. The system of claim 1 , wherein, in the instance the validation by the dynamic rule-based filtering is inconclusive, the validation based on the bare service-replica filtering is performed.

8. The system of claim 1 , wherein the database tuner as a service is spawned by the cloud provider as a Virtual Machine (“VM”) ware, multi-tenant container.

9. The system of claim 1 , further comprising:
a data federation agent, coupled to database service instance, to:
aggregate the database performance metrics of the database service instance.

10. The system of claim 1 , wherein the database service instance is associated with at least one of: (i) a relational database, (ii) a Structured Query Language (“SQL”) database, (iii) a Not only SQL (“NoSQL”) database, (iv) an in-memory database, (v) a messaging service, and (vi) an enterprise service bus.

11. A computer-implemented method to facilitate a database tuning as a service offered by a cloud platform as a service provider, comprising:
periodically determining, by a throttling detection engine associated with a database service instance based on an actual current performance throttling of the database service instance, whether an automated database tuning process should be performed;
transmitting, in response to the determination that the automated database tuning process should be performed, database performance metrics;
accessing, by a database tuner as a service coupled to the throttling detection engine in response to the determination that the automated database tuning process should be performed, aggregated database performance metrics of the database service instance;
determining a set of tunable parameters associated with the database service instance;
executing the automated database tuning process to recommend, using an intelligent algorithm, a new set of configurations for the set of tunable parameters to be applied to the database service instance; and
validating the recommended new set of configurations for the set of tunable parameters, the validation being based on (1) dynamic rule-based filtering validated against a pre-defined set of rules defined for the specific database service instance and (2) bare service-replica filtering of the database service instance excluding data of the database service instance.

12. The method of claim 11 , wherein the automated database tuning process uses a generic regression process on previously observed database workloads to make said recommendation.

13. The method of claim 11 , wherein the aggregated database performance metrics are associated with a dynamically calculated observation time.

14. The method of claim 11 , wherein the database performance metrics include at least one of: (i) a response time, (ii) a number of queued requests, and (iii) a throughput.

15. The method of claim 11 , wherein the set of tunable parameters includes at least one of: (i) memory knobs, (ii) background writer knobs, (iii) asynchronous and planner estimate knobs, (iv) locking knobs, and (v) an other relevant knobs.

16. The method of claim 11 , wherein the validating of the new set of configurations for the set of tunable parameters is evaluated by a recommendation and validation engine.

17. The method of claim 11 , wherein, in the instance the validating by the dynamic rule-based filtering is inconclusive, the validation based on the bare service-replica filtering is performed.

18. The method of claim 11 , wherein the database tuner as a service is spawned by the cloud provider as a Virtual Machine (“VM”) ware, multi-tenant container.

19. A non-transitory, computer readable medium having executable instructions stored therein, the medium comprising:
instructions to periodically determine, by a throttling detection engine associated with a database service instance based on an actual current performance throttling of the database service instance, whether an automated database tuning process should be performed;
instructions to, in response to the determination that the automated database tuning process should be performed, transmit database performance metrics;
instructions to access, by a database tuner as a service coupled to the throttling detection engine in response to the determination that the automated database tuning process should be performed, aggregated database performance metrics of the database service instance;
instructions to determine a set of tunable parameters associated with the database service instance; and
instructions to execute the automated database tuning process to recommend, using an intelligent algorithm, a new set of configurations for the set of tunable parameters to be applied to the database service instance; and
instructions to validate the recommended new set of configurations for the set of tunable parameters, the validation being

Assignees

• Sap Se

Inventors

• P Meenakshi Sundaram
• Tiwary Mayank
• Mishra Pritish
• Jain Shashank Mohan

Classifications

• G06F16/217 Primary

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06N5/04

  Inference or reasoning models · CPC title

• G06F11/3433

  for load management (allocation of a server based on load conditions G06F9/505; load rebalancing G06F9/5083; redistributing the load in a network by a load balancer H04L67/1029) · CPC title

• G06F11/3055

  Monitoring arrangements for monitoring the status of the computing system or of the computing system component, e.g. monitoring if the computing system is on, off, available, not available (error or fault processing without redundancy G06F11/0703; error detection or correction by redundancy in data representation G06F11/08; error detection or correction of the data by redundancy in operations G06F11/14; error detection or correction by redundancy in hardware G06F11/16) · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title