High Performance and Availability for Microsoft SQL Server on Diamanti

Microsoft SQL Server is one of the most popular database engines that enables enterprises to draw meaningful insights in real-time from their mission-critical workloads. With the growing popularity and adoption of containers and Kubernetes, Microsoft continues to add new features to support SQL Server deployments as Linux containers on Kubernetes. While Kubernetes has greatly simplified the task of deploying containerized stateful applications, there are several intentional gaps related to storage, networking, and infrastructure left for organizations to address. The underlying infrastructure also needs to support the scaling and performance requirements of the data-intensive database applications.

Diamanti Spektra abstracts all the Kubernetes complexities and offers a turnkey solution that makes it easy to deploy and manage any type of application across multiple Kubernetes clusters, spread across hybrid cloud environments. By running on the Diamanti platform, SQL Server benefits from the performance, scale, reliability, and availability of Diamanti Spektra. This blog highlights the benefits of deploying Microsoft SQL Server 2019 on the Diamanti platform.

Figure 1: Diamanti is the platform of choice for Microsoft SQL Server 2019

Superior Management and Data Plane Solution

Application Management and Migration

Diamanti allows enterprises to easily manage and migrate stateless and stateful applications across data centers and public cloud. This provides database admins and developers the flexibility to deploy applications to the most appropriate infrastructure driven by multiple factors such as cost, security, performance requirements, and geography.

The below video demonstrates the seamless deployment and migration of Microsoft SQL Server applications across on-premises and cloud clusters.


Defense in Depth 

No organization is immune from the risk of losing access to their applications and data. Whether you are running your SQL Server applications on-premises or in the cloud, it is imperative that your database admins set up a disaster recovery strategy that takes into account a range of RTO and RPO requirements.

Figure 2: Full Spectrum of Data Availability with Diamanti

Diamanti provides layers of defense against disaster. Diamanti Spektra offers a full spectrum of data availability features such as snapshots, mirroring, replication, disaster recovery, backup and restore to ensure enterprise deployments of Microsoft SQL databases are always online and healthy. Additionally, the platform provides software (volume encryption) and hardware-based (self-encrypting drives) security measures to protect against data theft and unintentional data loss.

Diamanti Spektra enables users to configure DR policies, including replication periods, at the push of a button. Check out this video to see how you can enable disaster recovery policy and seamlessly failover/failback Microsoft SQL Server application on the Diamanti platform.


Accelerate Performance with Diamanti Ultima

The Diamanti platform is built with performance at its core. For on-premises environments, the Diamanti platform offers Diamanti UltimaTM, a pair of second-generation PCIe based I/O acceleration cards that offload networking and storage traffic, freeing up compute resources to power modern applications. This minimizes IO wait time to ~0, giving customers 3x-30x performance improvement on data-intensive applications while getting consistent sub-100 microsecond latency, 1 million IOPS per node and significant TCO savings.


The Diamanti platform is ideal for running mission-critical databases, where high performance, resiliency, availability, and security are required. It provides best-in-class data plane services and security measures to protect application data. Moreover, the platform provides traffic isolation and guaranteed Quality-of-Service(QoS) allowing enterprises to maximize application performance and guard against “noisy neighbor” issues. To learn more, check out the webinar on how to “Supercharge Stateful Applications on Kubernetes”.