I'm building a low cost server for an ACT Database and website. Low volume only 10-15 users. ACT is built on top of SQL Server 2008. Okay, so i'm spec-ing out hardware and trying to save money since this isn't really a mission critical application for us. Hoping to buy only 4 SATA 6GB/s drives.
Do you guys think i should setup two mirrored RAID 1 arrays? ( one for OS one for database )
OR run all 4 disks in a single RAID 10 array
I guess Option 1 is more standard but i'm curious to see how Option 2 will perform... The focus here is performance since either option is reliable enough for the situation