Managing Memory to Meet Multiclass Workload Response Time Goals
Kurt P. Brown, Michael J. Carey, Miron Livny · 1993
In this paper we propose and evaluate an approach to DBMS memory management that addresses multiclass workloads with per-class response time goals. It operates by monitoring per-class database reference frequencies as well as the state of the system relative to the goals of each class; the information that it gathers is used to help existing memory allocation and page replacement mechanisms avoid making decisions that may jeopardize performance goals. 1 Introduction A widening range of application areas, as well as requirements for data sharing and continuous operation, are contributing to an increase in the diversity of workloads that a DBMS must be able to cope with. However, providing adequate performance for each class in a multiclass DBMS workload is still an open problem [Pirahesh 90, Brown 92, DeWitt 92]. A multiclass workload is characterized by distinct classes of work that may have widely varying resource demands, each with its own performance objective. A DBMS that is ...