ScaleIO SAN - Great for VMware, Not so great for SQL Server

Hello, we have a new miniseries coming up, we haven't decided on formats (Blog, Youtube, podcast...) but, we've recently gained a good deal of experience working with various SANs in virtualized environments, and their performance implications on SQL server. In fact, we've gone and built at test system with 5-node ScaleIO, 10 NVMe SSDs, 10 SATA SSDs and two late-model Xeon servers to form a cluster, desinged bunch of experiments to answer a lot of specific questions - like How does SAN compare to classic RAID? Does high IOPS matter? How good is NVMe SSD over SATA SSD? Is it true that SAN-hosted SQL tends to deadlock more? and so on.....what we found is really interesting, and this knowledge is worth sharing with the world. So, stand by...

Here's a sneak peek. How do you think this SAN would perform a basic SQL server workload? The answer: worse than a single laptop with Samsung 850 PRO SSD running Developer Edition SQL on i7, and through experiments we were able to identify the reason: Latency. This is despite the fact that we used low-latency champ of all connectivity, Infiniband. We even used dedicated HCAs for SDC traffic and SDS traffic, so we'd say it's not a terrible setup. In fact it ran file servers and virtual machines with power to spare...it just doesn't do SQL server well. Stay tuned to find out more!

148K IOPS


Featured Posts
Recent Posts