Configuring buffer pools in DB2 UDB
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Adaptive self-tuning memory in DB2
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more
Meeting performance goals with the HP-UX workload manager
WIESS'00 Proceedings of the 1st conference on Industrial Experiences with Systems Software - Volume 1
| Hi-index | 0.01 |
In this paper we present an online method for managing a goal oriented buffer partitioning in the distributed memory of a network of workstations. Our algorithm implements a feedback mechanism which dynamically changes the sizes of dedicated buffer areas and thereby the buffer hit rate for the different classes in such a way that user specified response time goals will be satisfied. The aggregated size of the buffer memory across all network nodes remains constant and only the partitioning is changed. The algorithm is based on efficiently approximating the trajectory of the per-class response time curves as a function of the available buffer. Changes in the workload that would lead to the violation of response time goals are counteracted by accordingly adjusting the buffer allocation. For local replacement decisions, we integrate a cost based buffer replacement algorithm to fit into our goal oriented approach. We have implemented out algorithm in a detailled simulation prototype and we present some first results with this prototype.