Autonomic workload execution control using throttling

— Database Management Systems (DBMSs) are often required to simultaneously process multiple diverse workloads while enforcing business policies that govern workload performance. Workload control mechanisms such as admission control, query scheduling, and workload execution control serve to ensure that such policies are enforced and that individual workload goals are met. Query throttling can be used as a workload execution control method whereby problematic queries are slowed down, thus freeing resources to allow the more important work to complete more rapidly. In a self-managed system, a controller would be used to determine the appropriate level of throttling necessary to allow the important workload to meet is goals. The throttling would be increased or decreased depending upon the current system performance. In this paper, we explore two techniques to maintain an appropriate level of query throttling. The first technique uses a simple controller based on a diminishing step funct...

• Type: Conference
• Year: 2010
• Where: ICDE
• Authors: Wendy Powley, Patrick Martin, Mingyi Zhang, Paul Bird, Keith McDonald
• Keywords: Database, Execution Control, ICDE 2010, Workload, Workload Control Mechanisms