Export (0) Print
Expand All

Physical Database Design

SQL Server 2000

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.
© 2014 Microsoft