SQLUSA

Microsoft SQL Server 2000 Best Practices

 

How to configure the hard disks for optimal performance?

 

The following configuration is reliable, high performance and low cost:

Drive C 30 GB RAID 1 mirrored hard drive: operating system

Drive D 60 GB RAID 1 mirrored hard drive: SQL Server software, temporary database

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

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

 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page