|
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
|
