Database Tuning

Definition

Database tuning is the deployment task during which the performance of the installed database(s) is tuned.

Objectives

The typical objectives of the database tuning task are to:

• Maximize the performance of the database(s).

Preconditions

The database tuning task can typically begin when the following preconditions hold:

• The delivery phase has begun.
• The deployment team has been adequately:
  • Staffed.
  • Trained in database tuning.
• The deployment planning task has completed.
• The data component installation task has completed.
• The database loading task has completed.

Completion Criteria

The application tuning task is typically complete when the following postconditions hold:

• The database(s) has been tuned to increase its performance.

Steps

The database tuning task typically involves the following teams performing the following steps in an interative, incremental, parallel, and time-boxed manner:

• Deployment Team:
  • TBD

Techniques

The database tuning task can typically be performed using the following techniques:

• Using performance analysis or profiling tools.

Work Products

The database tuning task typically results in the production of all or part of the following work products:

• Status Report

Guidelines

• This task is only appropriate for endeavors during which a database is to be delivered.