A framework for autonomic workload management in DBMSs

Abstract

In today's database server environments, multiple types of workloads can be present in a system simultaneously. Workload types may include on-line transaction processing and business intelligence. Workloads may also have different levels of business importance and distinct performance objectives, which are typically derived from service level agreements. An autonomic workload management system for database management systems (DBMSs) dynamically monitors and controls the flow of the workloads to help DBMSs achieve the desired performance objectives. In this paper, we present a framework and a prototype implementation for autonomic workload management in DBMSs. The framework and the prototype provide the ability to achieve performance objectives of workloads with diverse characteristics, different levels of business importance and varying resource demands while protecting DBMSs against performance failure. The prototype system is implemented on top of IBM^® DB2^® Workload Manager. Initial experiments using the prototype system are presented to demonstrate the effectiveness of the framework.