Importance

Loading Importance Indicators...

Abstract

Various embodiments herein each include at least one of systems, methods and software for dynamic in-flight database request throttling. One such embodiment includes monitoring a database or multi-database system Workload Definition (WD) to identify queuing of a higher priority request while the database system is processing requests of a lower priority and when queuing of a higher priority request is identified, adjusting a metric throttle for the WD to a new metric throttle level C_n, computed as the average of a metric level C_c that would drive the metric to a target T and a metric level C_r that would drive a rolling average of the metric to the target T. This embodiment further includes evaluating lower priority in-flight requests for the current workload to identify abort candidate requests to abort and aborting the identified abort candidate requests and place the aborted requests in a delay queue for later execution. Some embodiments of this method also include, when the metric T has not yet been met, identifying lower priority in-flight requests of the current workload to identify suspend candidate requests and suspending the identified suspend candidate requests and place the suspended requests in a suspend queue to complete execution later.

Loading the Abstract Image...

First Claim