When You Need More From Your OLTP Platform, Look To Micron SAS SSDs.
An OLTP workload is one of the most demanding in the Enterprise. With OLTP, it seems that everything matters. Order processing rates matter. Average response time matters. Response consistency matters. Moreover, with changing datacenter economics and value metrics, the amount of space in the rack also matters.
If OLTP matters to you, you probably know that SSDs can help. You know they are faster than hard drives, deliver better and more consistent responsiveness. You also know that for similar performance, an SSD based OLTP platform will use way, way less rack space.
However, is the difference between SSDs and HDDs really that big w/OLTP? Really? Yes, yes it is.
Facts are Friendly. Start There
We looked at Microsoft SQL OLTP Orders Per Minute (OPM) on our Micron S650DC SSD (2x SSDs in RAID 1) and on a pretty common HDD setup (12x 15K SAS HDDs in RAID 10) – note that the HDD array has six times as many drives as the S650DC array!
Both arrays have similar capacity – 1.6TB of SSDs and 1.8TB of HDDs. We ran both in identical host platforms.
We sized the database larger than memory, to make sure storage IO was part of the results. We focused on OPM, average response time and consistent response time (99.9th percentile latency). We also know that some SQL systems are lightly loaded (a handful of users) and some are more heavily loaded (just under a couple of hundred users), so we looked at both (and a few in between).
Facts are Friendly…to the SSDs Anyway
Where did we end up? As I noted above – we all expect the S650DC to show more OPM. The S650DC is a fast, 12Gb/s SAS SSD, so more OPM should be no surprise. But this may be: as shown in the chart below, the S650DC shows 8x to 23x more OPM than the HDDs. And remember: we used six times as many HDDs in this test!
Average latency? The S650DC is 8x to 22x better. Latency consistency? 3x to 29x better.
Surprised yet? Want to learn more? Take a look at all our SAS SSDs and learn more about this testing by reading the full Technical Brief. If you have questions about the testing we ran, tweet me @GreyHairStorage or connect with Micron on Twitter @MicronStorage and on LinkedIn.
About Our Blogger
Doug is a Senior Technical Marketing Engineer for Micron's Storage Business Unit, with a focus on enterprise solid state drives.