In the spin of SSDs on database servers
Interest in solid state drives (SSDs) is growing as their initially terrifying price plummets: Intel recently announced a 60 per-cent reduction in the cost of its X25-M Mainstream SATA SSD since its launch last year. SSDs are attractive because they radiate less heat than traditional spinning disks, they're smaller, quieter and …
This topic is closed for new posts.
Posted Wednesday 26th August 2009 09:11 GMT
SSD Spin cycle #
There's a reason why there hasn't been a single transaction-processing benchmark published on SSD. And there won't be any TPC-C or TPC-E result published either.
It's because the asymmetry of read-write performance gums up the works in any database that does any substantial amount of updates whatsoever.
Now, we do have a couple of published results for PCI-bus attached SSDs (the only ones that make any sense BTW) on the TPC-H data warehousing benchmark. That app should be a home-run for SSD because the workload consists of >95% random reads. So why then are the TPC-H systems with the best cost/performance (Kickfire, for example) still based on spinning disk?
In enterprise applications the performance advantage of SSD vs. HDD drop like a stone. The STEC Zeus-IOPS for example drops from 45,000 IOPS (advertised) to 5,000 (measured, SPC-1C/E) That's still fast, but not worth $20,000 when you can get the same number of SPC-1 IOPS from an array of 10Krpm disks costing less than $6,000. For the difference in price, you can even buy 15yrs worth of electricity to run them, not to mention several terabytes of additional capacity for "free".
I think the REAL story that you guys should be publishing is titled: "where's the beef: why SSD manufacturers like STEC refuse to publish audited application performance benchmarks."
This topic is closed for new posts.
Most read
Popular Whitepapers
- Transforming IT culture
to assure business service quality and improve IT operational efficiency - The Register Webcast: Storage Virtualization
An introduction to the implications for enterprise IT - The Register Webcast - Desktop Support : The Hub of IT
Watch the webcast of The Register's recent desktop support seminar - The Great Virtualization Debate
Practitioner insights into the where, why and how - The Register Guide to managing spam
A primer on the implications for enterprise IT - The Register Guide to iSCSI
A primer on Internet SCSI, a protocol to transport SCSI commands over IP
Driving Situational Awareness:
Reshaping IT
Assuring application service quality
Application Performance Management: