SAS vs SATA in RAID 0?
Posted on 2010-01-08
I am trying to configure a new computer (from Dell) for my database guy. He has at least 2 full-blown SQL instances on his desktop. His current machine is a little over 3 years old. It has 2 10k RPM SATA hard drives (Western Digital-EX, if that makes any difference) in RAID 0. This new one that we are getting has a better processor and better ram, but I figure that won't matter TOO much if his hard drives were his bottle neck in the first place (because he does so much reading and writing). So my question is: If I'm running two drives in RAID 0, would I really see that much of a performance increase going with SAS 10k over SATA 10k?
And just out of curiosity, what about SAS 15k over SATA 10k?