Solid state storage for SQL Server is here. 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. With recent improvements in solid state storage for SQL Server, it’s time to consider SSD devices for SQL Server storage.
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.
Why Should You Consider Solid State Storage for SQL Server?
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 Solid State Drives (SSDs). He stressed that SSDs are ready for the enterprise today. His description of the things to look out for when purchasing SSDs was quite useful – kind of like the Consumer Reports of SSDs.
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 SSDs pointed out that you don’t purchase SSDs 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.