Hello! It’s been a while since I’ve shared my last blog, mostly as I have been so busy working with different OEM partners on enabling VMware Virtual SAN (VSAN) solutions.
VMworld 2015 US is around the corner, taking place next week! My colleague, Beth Caltagirone, has written a nice blog elaborating on SanDisk®’s broad presence and participation at VMworld. You can read the blog here.
In this post, I would like to share some exciting, new results we achieved working with one of our partners, Lenovo. This solution is the first time I have ever seen such a large number achieved for a transaction processing system using VMware Virtual SAN. The white paper and other details will be published post VMworld 2015 US, but I would like to share a glimpse of it with you now, ahead of the show.
For this solution, we have been working with our partner Lenovo on enabling Virtual SAN for business critical applications. One of the workloads we have chosen to test is an online transaction processing system (OLTP) using SQL Server database
We configured a 4-node all-flash Virtual SAN using Lenovo System X3650 M5 servers. We used 2 VMs in each node (in a 4-node all-flash cluster) and ran the OLTP workload simultaneously on each.
We used “HammerDB”, a database load-testing tool, to create 5,000 OLTP warehouse in each Virtual Machine (VM), simulating real-world online transactions. We ran 8 VMs in this 4-node all-flash VSAN, totaling 40,000 OLTP warehouse (~8TB of Database). This large OLTP database is simulated by running 2,000 users simultaneously.
In simplified terms, this test simulates 2,000 end users simultaneously performing a transaction (e.g. a purchase, checking their order status, looking for inventory, adding to shopping cart etc.) in an 8TB database.
Subscribe to Blog via Email
By providing your email address, you agree to the terms of Western Digital's Privacy Statement
From a VM perspective, each VM was configured with 16 vCPU and 96GB of RAM and with 8 virtual disks storing ~1TB of data. The reason to choose a 16 vCPU is in order to maintain a standard SQL server license. This helps significantly in keeping the cost of the solution low.
Here are the results of our testing for the New Order Per Minute (NOPM):
The test results were no less than astounding and demonstrate that for business critical applications, VMware Virtual SAN is an ideal solution. And as VMware Virtual SAN supports up to a 64-node configuration, by extrapolating this 4-node test results linearly, we can achieve up to 48 million NOPM!
This configuration is currently undergoing testing and we will have additional details published soon in a white paper. The numbers and metrics that will appear in the final document may change slightly from the initial testing results that I’ve shared here, but regardless, this is an incredibly fast system for running business critical applications and databases.
I will be at VMworld in SanDisk booth #1920 and hope to see many of you there. I look forward to discussing the details of the different solutions we offer for hyper-converged infrastructure, especially using software-defined storage technology.
Biswapati brings over 12 years of experience in the IT industry. He has been involved with the virtualization industry for more than 8 years and held different roles in Quality Engineering, Performance Benchmarking, Pre-sales Technical and Solution Architecting.At SanDisk, he is responsible for building solutions, reference architecture, deployment guides, best practices for enterprise applications (Tire-I and II) using Enterprise SSD, ULLtraDIMM and Flash-based software products in virtualization platform.Prior to SanDisk, Biswapati was contracting with VMware and was part of VMware Alliances team. During this time he worked closely with many VMware ISV partners in the areas of Desktop, Server, BCDR and Cloud solutions for performance and functional validation of ISV products. Biswapati was a speaker in VMworld 2013 session for “Application performance in VDI environment.He received a Bachelor of Engineering from National Institute of Technology, India.