DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS  SQL 2012 PROGRAMMING  DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
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

For additional performance gain place tempdb log on a dedicated RAID 1 drive.

Related articles:

Hard Drive Configurations for SQL Server

Storage Top 10 Best Practices

Deciding the best disk configuration for your SQL Server

About hard drive configuration for SQL Server

SAN Storage Best Practices for SQL Server

Deploying SQL Server 2005 with SAN #1

SQL Server 2005 Configuration Blog #2.doc

Deploying SQL Server 2005 with SAN #3

SQL Server Script Resources for IT Professionals

 

Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE