SQL server hardware configuration

Question

What is the best strategy in the hardware configuration of a SQL server machine?

To my knowledge you set it up the following:

RAID 1 (2 disks) --> OS + SQL Server installation RAID 1 (2 disks) --> SQL Server Logs RAID 5 (4 disks) --> SQL Server databases

What have you experienced?
Is there a better way to do it?

Thanks, Dimi

Answer 1

Take a look at This Stackoverflow question. It goes into setting up SQL server disk layouts.

Answer 2

I think this is excellently covered in this article. There isn't a single clear cut answer it depends on what the server will be used for and what kind of load it will face and in what manner. And the article will give plenty of suggestions on how to reach your decision.

Answer 3

Browse http://www.brentozar.com/sql/ . Brent have some suggestion on hardware config.