It is worth noting that Gartner has posted a report detailing who the flash/SSD vendors are and what marketshare they own. It is defintely worth reading Gigom’s article and The Register’s article on the topic.
Microsoft has released a new whitepaper that should be of interest to those that virtualize SQL Server using Microsoft’s virtualization technologies. This guide provides high level best practices and considerations for deploying and managing Microsoft SQL Server 2012 on Microsoft virtualization infrastructure.
If you missed it there is a nice best practices technical paper (you need to sign up to download it) on how to accelerate Microsoft SQL Server on an all-flash Violin Memory array. You can see the accelerated performance of running on SQL Server on Violin here.
Matt Henderson, a database and systems architect at Violin Memory, has published a great article on the difference in modernizing versus revolutionizing storage in your data center. In the article he discusses a number of aspects – change in storage in the datacenter – comparing SSDs and flash arrays. Good read for those confused about what does and doesn’t happen when shifting to SSDs or flash arrays.
The arrival of Big Data frameworks has brought with it NoSQL databases. With those databases are questions about scalability and performance. Increasingly, it is becoming clear that both can be seriously answered with flash. Not simply SSDs, but enterprise flash which vastly outperforms them. Two excellent technical papers on running NoSQL databases on flash are on my recommended reading list. In the first, the topic is running Cassandra on top of Violin Memory’s flash arrays and in the second the topic is around HBase.
The alternative to buying an expensive Exadata solution is to use Violin Memory Arrays to quite simply provide a high performing Oracle database software/server/storage combination. Which is after-all what Exadata does. However, in order to do that – it is important to follow some best practices. To help facilitate that – Violin Memory has released a nice best practices technical paper aimed at showing how best to deliver high performance to your Oracle solutions by running them on Violin Memory flash products.
Often, the question comes up how solutions built around SSDs or Violin Memory arrays compare with Exadata. A short time ago there was a nice benchmark that provided that some answers. Ashminder Ubhi provided some nice numbers for us to look at. A quick snapshot showing the big picture :
Using the SLOB benchmark – the different configurations in questions were run and the results might be surprising to some people. Recommended reading for those interested in understanding performance differences under different workloads.
If you are working with the Microsoft enterprise offerings – this may be of interest. The Microsoft Fast Track Data Warehouse guide are reference architectures which are a combination of Microsoft SQL Server software running on prescribed hardware configurations that have been tested and approved for data warehouse workloads by Microsoft. More information can be found here.
Let’s start by saying that the title is a little deceptive. I think that traditional hard disk is over. You can start by seeing it in PC and Apple computer sales. Look at the Apple’s laptops which offer SSDs as replacements for hard disks. Or Sony which offers SSDs or at worst they offer traditional hard disks with a flash-based cache SSD. These are the consumer side of the flash revolution. Violin Memory provides extreme performance for the opposite end of the spectrum – the enterprise. One of the key benefactors of enterprise flash is the database. Figure 1 has a six reasons that only begin to scratch the surface.
This only scratches the surface.