Looking for info on disk configurations for SQL Server

[Vertigo]

Can anyone hook me up with some links to decent info on the best way of configuring disk subsystems for an SQL Server box.

Basically I don't have the world largest budget but am looking for the best bang-for-buck configuration I can manage.

I'm looking at a hybrid system of SSDs and HDDs as there'll be too much data to store on SSDs alone.

My initial idea was to use a couple of mirrored SSDs to hold the log files and then store the databases on a set of four HDDs in a RAID10 configuration.

I'm wondering whether this would be the best route or whether restricting the SSDs to log file duties only would be a waste and perhaps I'd be better off with another system, perhaps using the SSDs as caches for the HDDs in some way?

Would appreciate any info people have on this

 

[Vertigo]

Thanks for the input.

Yeah we don't need enterprise levels of performance, just need a box which can host quite a few SQL databases for internal development purposes.

For HDDs, is RAID5 a viable alternative to RAID10? From what I understand, write performance on RAID5 can be an issue unless you throw a decently beefy controller at it or is this ancient history now and most modern controllers are capable of handling RAID5 easily?