No SQL code changes.
Condusiv V-locity Introduction
Whether running SQL in a physical or virtualized environment, most SQL DBAs would welcome faster storage at a reasonable price.
The V-locity® software from Condusiv® Technologies is designed to provide exactly that, but using the storage hardware that you already own. It doesn’t matter if you have direct attached disks, if you’re running a tiered SAN, have a tray of SSD storage or are fortunate enough to have an all-flash array; that storage layer can be a limiting factor to your SQL Server database productivity.
The V-locity software reduces the amount of storage I/O traffic that has to go out and be processed by the disk storage layer, and streamlines or optimizes the data which does have to still go out to disk.
The net result is that SQL can typically get more transactions completed in the same amount of time, quite simply because on average, it’s not having to wait so much on the storage before being able to get on with its next transaction.
V-locity can be downloaded and installed without any disruption to live SQL servers. No SQL code changes are required and no reboots. Just install and typically you’ll start seeing results in just a few minutes.
Before we take a more in-depth look at that, I would like to briefly mention that last year, the V-locity software was awarded the Microsoft SQL Server I/O Reliability Certification. This means that whilst providing faster storage access, V-locity didn’t adversely affect the required and recommended behaviors that an I/O subsystem must provide for SQL Server, as defined by Microsoft themselves.
Microsoft ran tests for this in Azure, with SQL 2016, and used HammerDB to generate an online transaction processing type workload. Not only was V-locity able to jump through all the hoops necessary to achieve the certification, but it was also able to show an increase of about 30% more SQL transactions in the same amount of time.
In this test, that meant roughly 30% more orders processed.
They probably could have processed more too, if they had allowed V-locity a slightly larger RAM cache size.
To get more information, including best practise for running V-locity on MS SQL servers, easy ways to validate results, customer case studies and more, click here for the full article on LinkedIn.
If you simply want to try V-locity, click here for a free trial.
Use the V-locity software to not only identify those servers that cause storage I/O issues, but fix those issues at the same time.