The Quantifiable Benefits of SSDs
I attended the Flash Memory Summit in Santa Clara this week and am writing several posts to discuss all that I learned.
Sumeet Bansal is now an architect with SSD vendor Fusion-io but before he joined his present employer, he was VP if IT at online wine seller wine.com, which has a large gift-giving business that peaks in November and December each year. Based on growth patterns, it was clear that wine.com needed an immediate 30% boost in database performance to handle both the incoming orders and the shipping and invoicing systems. The company’s server architecture had in-built bottlenecks that caused all database operations to affect others, so that a peak in one operation would slow others.
One possible way to improve server database performance was to add drives to the system’s existing storage area network (SAN). A cost analysis showed that the company could not afford the number of drives it would need to boost performance to the required levels. Instead, wine.com elected to perform a forklift server upgrade, exchanging proprietary SAN servers for standard HP servers and PCIe-based solid-state drives (SSDs) set up as two RAID 1 pairs, which provided one level of redundancy. In addition, the SSD RAID drives were synchronously mirrored onto hard disk drives for fast recovery. As I’ve been discussing in my most recent posts, SSDs deliver 100-200x the IOPS (I/O operations per second) performance of hard disks.
Here are the results of the change at wine.com:
- 1200% performance improvement in writes (average)
- 1400% performance improvement in reads (average)
- Average downtime duration went from 8 hours to less than 10 minutes due to mirroring
- Latency went from 4 msec to 1 msec for writes, 12 msec to 1 msec for reads
- Average SQL transaction went from 345 msec to 88 msec (~4x improvement)
- Database backup time dropped from 2 hours to 6 minutes
- Database restore time dropped from 3 hours to 15 minutes
“So, is it (an SSD) expensive?” asked Bansal. Cost in an enterprise environment means more than just hardware cost. “SSD is definitely taking us places,” he concluded.
Steve Leibson commented:
Eremeeff commented:
Steve Leibson commented:
Tired of Hype commented:
Steve Leibson commented:
Tania commented:
Steve Leibson commented:
Tired of hype... commented:















