SQLUSA.com
SQL SERVER 2008 GRAND SLAM
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL JOBS SQL Server Training Scripts JOB BANK
  SQL Server 2008 Training Scripts  
  SQL Server 2005 Training Scripts  
News SQL Server Articles SQL Format

How to configure the hard disks for optimal performance?

Disk is the slowest part of the computer. Physical movements involved two ways: disk read/write head positioning to a track and spinning of the disk. Therefore it is crucial to have sufficient high-performance disk resources and configure them for optimal performance. RAM memory caching at different levels is helpful to overcome the disk sluggishness.

The following SQL Server disk drive configuration is reliable, high performance and relatively low cost:

Drive C 60 GB RAID 1 mirrored hard drive: operating system / SQL Server software

Drive D 60 GB RAID 1 mirrored hard drive: temporary database (tempdb) data file

Drive E 300 GB RAID 5 hard drive array: application database data files

Drive F 60 GB RAID 1 mirrored hard drive: transaction logs

Drive G 120 GB RAID 0 hard drive: staging files - feeds, disk-to-disk-to-tape backups, etc.
    Note: RAID 0 is not redundant

Related articles:

Hard Drive Configurations for SQL Server

Deciding the best disk configuration for your SQL Server

About hard drive configuration for SQL Server

Deploying SQL Server 2005 with SAN #1

SQL Server 2005 Configuration Blog #2.doc

Deploying SQL Server 2005 with SAN #3

 

Order SQL 2008 GRAND SLAM Today!
SQLUSA.com Home Page
SQL Server Training at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
Microsoft SQL Server 2000 Training Videos at www.sqlusa.com.

FREE SQL & Business Intelligence / OLAP Short Videos on YOUTUBE.com

Microsoft Community Contributor 2011
Invest in Your SUCCESS!

Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts


Copyright 2005-2011, SMI Corp. All Rights Reserved.

SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.