Tuning Database Configuration Parameters With iTuned
Source: VLDB Endowment
Database systems have a large number of configuration parameters that control memory distribution, I/O optimization, costing of query plans, parallelism, many aspects of logging, recovery, and other behavior. Regular users and even expert database administrators struggle to tune these parameters for good performance. The wave of research on improving database manageability has largely overlooked this problem which turns out to be hard to solve. The authors describe iTuned, a tool that automates the task of identifying good settings for database configuration parameters.