I just finished the SQLIO testing of the OWC Mercury Extreme Pro RE SSD's.
Platform Details: Dell PowerEdge 6950, 4x Dual-Core AMD Opteron 2.6ghz CPU's, 32GB RAM, Dell Perc 5/i RAID Adapter. RAID details: RAID10, 1MB Stripe Size, Adaptive Read Ahead, Writeback Cache, Windows Server 2008 R2 Standard. I used 4x of the 200GB version of the drive in RAID10 and installed WS2008R2 on that array.
The results were about what I was expecting. See below.
The full details are available here.
So what's the summary? SSD's in RAID perform about 2 times as fast as whatever you had in the RAID before?
ReplyDelete15k SaS RAID was what I used previously. The SSD was approximately twice as fast in benchmark numbers. Real-world SQL workloads have been twice as fast up to or even 10x faster.
ReplyDelete