Hi there. I have a new storage subsystem with two 15-drive SAS
enclosures, and I'm wondering how to set it up for my databases (a
150GB data warehouse and a 50GB plain old database, among others). My
initial idea was 1 hot spare per enclosure and a 28-drive RAID-10 (SAME
configuration), but yesterday I was dismayed to find that RAID-10 only
supports up to 16 drives (does anyone know the reason for this, by the
way?). So I'm considering a single RAID-50 (SAME), though I doubt this
will be fast enough for writes (e.g. index rebuilds), two RAID-10's
(with filegroup balancing, I guess), and RAID-100 (SAME) using Windows
(Server 2003 x64) to stripe across two 14-drive RAID-10's. Has anyone
done this? I'm planning on benchmarking all these different
configurations before moving the databases, and of course I'm always
open to general tips and advice.

Thanks,
Seth