Database Tuning

We also offer a group of activities used to optimize and homogenize the performance of a database. It usually overlaps with query tuning, but refers to design of the database files, selection of the database management system (DBMS), operating system and CPU the DBMS runs on. Our primary goal is to maximize use of system resources to perform work as efficiently and rapidly as possible. Most systems are designed to manage work efficiently, but it is possible to greatly improve performance by customizing settings and the configuration for the database and the DBMS being tuned. Database tuning usually involves 3 specific tasks, namely:

• Input/Output tuning: I/O is generally the most data-heavy operation in database work, and is typically the first bottleneck in database performance encountered.
• DBMS tuning refers to tuning of the DBMS and the configuration of the memory and processing resources of the computer running the DBMS.
• Database maintenance includes backups, column statistics updates, and defragmentation of data inside the database files.