Thread replies: 5
Thread images: 1
OP2015
RAID
2015-12-22 04:49:54 Post No. 918468
[Report]
Image search:
[Google]
RAID
OP2015
2015-12-22 04:49:54
Post No. 918468
[Report]
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