Abstract

performance of Database Management System(DBMS) is significantly affected when the key tuning parameters are altered. Most DBMS come along with several hundred tuning parameters. It is therefore important to identify only a few important tuning parameters and evaluate their effect on the system performance. The effect of each of the tuning parameter must be thoroughly understood so as to predict the performance when these parameters are altered. It is also important to understand the range of the tuning parameter over which tuning is most effective. Over tuning may lead to poor utilization of system resources. In this paper, a mathematical model is presented to predict the effect of one of the most important tuning parameter, namely, the buffer cache size and the model output is compared with experimental result. The model shows very close match with the experimental results.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.