RAID

File: promise_ex16350.jpg (54KB, 500x375px) Image search: [Google]

54KB, 500x375px

So I want to build a machine for "QA" a SQL 2008 R2 Database.

I am planning on buying a "normal" Desktop motherboard, and a PCI Raid Card

I want to install 4 SSD using a RAID 1+0 configuration.

My question here is, should I use a Cached RAID Card or an uncached one?

I won't be doing RAID5, and RAID 1+0 with SSD should be fast enough

Would a cached RAID Card give me way more performance than an uncached one? Considering That I will ONLY do RAID 1+0.

>Mandatory UPS if using a cached raid card
Not a problem with that

>RAID 1+0 is not as secure as RAID5
doesn't matter, I will do this on QA phase

>RAMDisk is way faster than that
I am aware of that, but in this case I need to do it without using RAMDisk

>Why use a Desktop Motherboard instead of a server motherboard
Unless there is a real performance benefit of using it, I see no point on doing that because I alredy have a Server for Production

>PCI SSD drives are way faster
Yeah, but they cost $$$$$$$$$$
And its not like the $$$$$$$ is a problem, is just that if I ever get a PCI Express SSD drive, it will directly go any other Server in here. "Random" IT policies or whatsoever in here...

>Some motherboards some with integrated RAID...
yes, but they SUCK. been there, done that. They SUCK. don't ever do that!!!!

>SQL 2008 R2 is...
yes I know, but I must use SQL 2008 R2, its a must.

>I have no experience and whatsoever, and I recomend using Xyz, based on nothing
I am cool with that :) thank you

>Here is a link/source that states that using a xyz
thank you, I really appretiate