Data Management

iTuned: A Tool for Configuring and Visualizing Database Parameters

Download Now Date Added: Jun 2010
Format: PDF

iTuned is a tool that takes a SQL workload as input and recommends good settings for database configuration parameters such as buffer pool sizes, multi-programming level, and number of I/O daemons. iTuned also provides response-surface and sensitivity analysis plots that help database users analyze the impact of each parameter. iTuned has the following novel features: a technique called Adaptive Sampling that proactively brings in appropriate data through planned experiments to find high-impact parameters and high-performance parameter settings, an executor that supports on-line experiments in production database environments through a cycle-stealing paradigm that places minimal overhead on the production workload, and portability across different database systems.