Physical Database Design

Optimizing SQL Database Performance

Optimizing Database Performance

Physical Database Design

The I/O subsystem (storage engine) is a key component of any relational database. A successful database implementation usually requires careful planning at the early stages of your project. The storage engine of a relational database requires much of this planning, which includes determining:

  • What type of disk hardware to use, such as RAID (redundant array of independent disks) devices. For more information, see RAID.

  • How to place your data onto the disks. For more information, see Data Placement Using Filegroups.

  • Which index design to use to improve query performance in accessing data. For more information, see Index Tuning Recommendations.

  • How to set all configuration parameters appropriately for the database to perform well. For more information, see Optimizing Server Performance.