Ginneblog

Perspectives on business and technology

Solid State Drives: SQL Server 2008 at the Speed of Light

Perhaps you’ve heard this astonishing figure.  At Amazon.com, every 100 ms of latency costs the company 1% in sales. Sumeet Bansal, Principal Solutions Architect at Fusion-io, referenced the Amazon study as he separated myth from reality about Solid State Storage and its role in the modern Database enterprise system.  

Fusion-io is a producer of enterprise-class SSDs.  Their silicon-based storage architecture known as ioMemory applies flash memory to large-scale enterprise storage products like Storage Area Networks.

View more documents from Mark Ginnebaugh.

Sumeet’s presentation to the Silicon Valley SQL Server User Group on Tuesday included a variety of reasons why SQL Server  DBAs, as well as other technologists, should be excited about SSD’s.  He stressed that SSD’s are ready for the enterprise today.  His description of the things to look out for when purchasing SSD’s was quite useful – kind of like the Consumer Reports of SSD’s.

This list of differentiators is probably part of why Steve Wozniak joined Fusion-io as Chief Scientist – “the Woz” wouldn’t put his energies into anything but the most promising technologies.  And neither would Sumeet, who came over to Fusion-io from Wine.com, where he was VP of IT at the San Francisco company.

David Leston walked away happy, and probably stayed up very late installing his blazingly fast 320 GB Fusion-io Solid State Drive (SSD).  He won the coveted door prize, which was generously donated by Fusion-io. 

I hadn’t met David before tonight, but he was on the same wavelength as our speaker.  Sumeet’s discussion of SSD’s pointed out that you don’t purchase SSD’s based on cost per GB, but rather by the value of the performance gains and reliability. 

It was particularly interesting to hear comments from the audience about how Microsoft and other vendors will start optimizing performance based on SSD-equipped systems, in addition to conventional drives.  Right now there’s an assumption of significant latency when going to the drive.  As the operating systems see great reductions in latency, additional optimizations will add to the performance gains of this breakthrough technology.

Sphere: Related Content

1 comment

1 Comment so far

  1. [...] learned more about SSD’s during the Fusion-io presentation to the Silicon Valley SQL Server User Group.  The DesignMind team has also been evaluating SSDs to [...]

Leave a reply