Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
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?

share|improve this question

marked as duplicate by Mark Henderson, Ben Pilbrow, John Gardeniers, mrdenny Dec 15 '10 at 9:59

This question was marked as an exact duplicate of an existing question.

Also regarding the RAID level choices,… (was before so it survived being asked on StackOverflow) – ManiacZX Dec 15 '10 at 1:31

The overall layout you've given is what we use for DBs with direct-attached storage. We're a Dell shop, so we use 15-spindle MD3000 arrays for this sort of thing.

Don't bother with a dedicated swap spindle. If you're hitting the swap hard enough to dedicate a spindle to it (hitting swap much at all, really) something is Very Wrong.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.