Building optimal custom machine for Sql Server
- by Chad Grant
Getting the hardware in the mail any day.
Hardware related to my question:
x10 15.5k RPM SAS Segate Cheetah's
x2 Adaptec 5405 PCIe Raid cards
Motherboard has integrated SAS raid.
Was thinking I would build 2 RAID 10 arrays one for data and one for logs
The remaining 2 drives a RAID 0 for TempDB
Will probably throw in a drive for OS.
Does putting the Sql Server application / exe's on a raid make a difference and is there any impact of leaving the OS on a relatively slow disk compared to the raid arrays?
I have 5/6 DBs combined < 50 gigs. With a relatively good / constant load. Estimating 60-7% reads vs writes.
Planning on using log shipping as well if that matters.
Any advice or suggestions?