From Diamanti, Report on Fastest SQL Server Performance at Lowest TCO

Diamanti, Inc. announced results from a recent industry benchmark report that show SQL Server 2019 running on Diamanti outperforms AWS Nitro with IO2 disks by 6x and Azure with Azure Ultra disks by 4x.

The report, conducted by McKnight Consulting Group (MCG), an independent consulting firm, also demonstrated that the company’s solution provides the lowest TCO at up 13x less than AWS and up to 10x less than Azure.

As data continues to grow and maintains its stronghold as the most valuable commodity for today’s modern enterprises, the proliferation of SQL Server to optimize transactional performance and unleash real-time insights from data has also accelerated. Simultaneously, with the growing popularity of containerization and Kubernetes, Microsoft is putting significant effort into bringing SQL Server 2019 to Linux containers. With this new approach, IT departments can provision applications quickly without legacy IT complexities.

To help customers determine the right platform to support their hybrid cloud strategy and provide the flexibility to deploy SQL Server to the most appropriate infrastructure, MCG conducted a benchmark study of SQL Server 2019 running on the most promising Kubernetes platforms available on the market. The results revealed Diamanti is 10x less expensive and 4x faster while running SQL server compared to Azure with Azure Ultra disks and 13x less costly and 6x faster compared to AWS Nitro with IO2 disks.

TPC-H performance comparison of Microsoft SQL sever on various platforms
Click to enlarge

“We work closely with our customers to understand their current challenges and emerging needs. In our conversations, it has become clear enterprise users need a solution to deploy containerized SQL Server across the hybrid cloud,” said Tom Barton, CEO. “While performance is the top priority for many of our customers, the TCO is a critical component of many IT departments’ decision-making process. The MCG study proves that Diamanti is the clear winner on both speed and cost.“

Click to enlarge

Enables enterprises to effectively manage modern applications
The company’s Kubernetes management platform differentiates itself from conventional architectures by leveraging a container-native storage and networking plane that offers performance NVMe storage and QoS guarantees across performance tiers. For on-premises environments, the firm’s platform offers Ultima offload, a pair of second-gen PCIe-based I/O acceleration cards that offload networking and storage traffic, freeing up compute resources to power modern applications.

Click to enlarge

Ultima offload

The firm also offers a spectrum of enterprise features such as snapshots, mirroring, replication, DR, backup, and restore to ensure that the enterprise deployments of SQL databases are always online and healthy. It allows enterprises to migrate and failover/failback (DR) applications across data centers and public clouds. Additionally, the platform provides software (volume encryption) and hardware-based (self-encrypting drives) security measures to protect vs. data theft and unintentional data loss.

Methodology
MCG runs all of its performance tests to ethical standards. The report results are the objective and unbiased results of the application of queries to the simulations described in the report.

Full report (registration required)

Resources:
Blog: Containerized Microsoft SQL Server 2019 Performance Testing Report      
Blog: Accelerate Microsoft SQL Server Performance at the Lowest TCO on Diamanti     
High Performance and Availability for Microsoft SQL Server on Diamanti