What is the best way to configure 6 disk raid for SQL Server + OS?
As a general rule what would be an ideal disk layout for a SQL server which is mainly used for a fairly read and write intensive web app?
Would the following be good?
Logical Disk 1 - RAID 1 - OS and SQL Server Program Files Logical Disk 2 - RAID 10 - SQL data files Logical Disk 3 - RAID 1 - SQL log files Logical Disk 4 - RAID 1 - TempDB files
Anythign else? I have seen some configurations with a seperate disk for the windows swap file?
Also this setup would have a minimum requirement of 10 physical disks. That is a lot of disks? I'm looking at a rack of server just now and all of them have space for six disks? How do people normally accommodate the need for more disks? SAN storage?