Condusiv continues its long-standing 20+ year relationship with Microsoft® as a Gold Partner and provider of technologies to Microsoft over the years.
In a testament to our technology quality and stability, Condusiv® became the first software vendor awarded the stringent certification of MS-SQL Server I/O Reliability, joining a very short list containing the likes of Dell® / EMC®, IBM® and HPE®.
Microsoft developed the SQL Server I/O Reliability Program to ensure the reliability, integrity, and availability of vendor products with SQL Server. The program includes a set of requirements that, when complied with and approved by a Microsoft committee of engineers, ensure the product is fully reliable and highly available for SQL Server systems. The certification applies to SQL Server running on Windows Server 2008R2 and later.
Certified for SQL I/O Reliability and Demonstrates Significant SQL Performance Gains
The program itself does not require performance characteristics of products, but it does require I/O testing to exhibit the reliability and integrity of the product. To that end, the full report links to a summary of before/after performance results from a HammerDB test (the preferred load test to measure MS-SQL performance) on Azure to demonstrate the gains of using Condusiv’s I/O reduction software for SQL Server 2016 on Azure’s Windows Server 2016 Data Center Edition.
While transactions per minute increased 28.5% and new orders per minute increased by 28.7%, gains were considered modest by Condusiv’s standards since only a limited amount memory was available to be leveraged by our patented DRAM caching engine. The typical Condusiv customer sees 50% or better performance improvement to SQL applications. The Azure test system configured by Microsoft did not boost available memory to showcase the full power of what the Condusiv software can do with as little of 2-4GB of memory.
To read the full report CLICK HERE
(Originally published September 15, 2017, updated December 30, 2019)
More resources to improve SQL Performance
Article: 6 Best Practices to Improve SQL Query Performance
Case Study: University of Illinois Doubles SQL and Oracle Performance on Flash Arrays
Article: Thinking Outside the Box – How to Dramatically Improve SQL Performance, Part 1
Article: SQL Server Database Performance
Webinar: MSSQLtips Webinar: SQL Server on VMWare Performance Optimization
Webinar: MSSQLtips Webinar: Improving SQL Server Virtual Machine Storage Performance
Do Your SQL Servers Have an I/O Performance Problem?
Find out by running the free Condusiv I/O Assessment Tool. It gathers 11 key performance metrics and performs statistical analyzes looking for potential problems. It then displays these metrics to help you understand where potential bottlenecks might be.
Leave A Comment
You must be logged in to post a comment.