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 VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES
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
SQL 2016 DESIGN & PROGRAMMING
 
 
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