Modeling of DBMS Memory for Performance Tuning

The 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.

Provided by: International Journal of Computer Applications Topic: Data Management Date Added: Mar 2012 Format: PDF

Find By Topic