Datrium Solution for Microsoft SQL Server

Get high performance and availability for your virtualized SQL Servers while improving security and gain failproof on-demand DRaaS with VMware Cloud on AWS.

Scroll to Section

CUSTOMERS

Customers Love the Datrium Solution for Microsoft SQL Server

 Queries now happen instantly. Storage is no longer a bottleneck. We were blown away to see 3.8x data reduction versus our previous storage solution. I used to spend about one day a week managing storage. Now, it’s down to zero. 

– Cameron Joyce, Senior Systems Engineer, Altair Global

FEATURES

Automatrix Delivers Industry-Leading SQL Server Performance, Availability, and DR

High Performance at Scale

Datrium DVX delivers high IOPs and low latency by maintaining data in local flash storage on the virtualization host running Microsoft SQL Server. This functionality results in 50-80% lower latency and up to 5x faster SQL queries than traditional architectures. Because resources are local to the host, performance scales as you add more hosts, and workloads are isolated from noisy neighbors.

Highly Available and Protected

When Microsoft SQL Server is deployed with Always-On Availability Group (AOAG) on DVX, the second host picks up immediately with the same performance from local flash if the primary host fails. Whether you decide to deploy SQL Server with or without AOAG, DVX has built-in backup that ensures you get an instant restart of your data from millions of point-in-time consistent backups.

Failproof One-Click Disaster Recovery

Whether you use a second site or the cloud as your DR site, Automatrix delivers failproof DR for SQL Server with one-click failover and failback. With RTO and RPO of a few minutes, your critical data restarts quickly, so the business impact is small. Costs are 10x lower with on-demand DRaaS with VMware Cloud on AWS and failback, which only sends changed data after global deduplication.

Encryption Without Compromises

Automatrix Blanket Encryption protects your data in host memory, across the network, and at rest in the data node or the cloud without the tradeoffs of other solutions. Even the backup data managed by DVX is encrypted. Customers get high performance and data reduction with encryption enabled because DVX encrypts inline after data reduction, leveraging CPU instructions on the host.

Virtualize for Easier Management

Manage Microsoft SQL Server virtual machines (VMs) through vCenter and stop managing storage separately. You don’t spend any time rebalancing databases across LUNs to optimize performance or availability. Copy your production database instantly for your test/dev teams. Workloads are isolated on their host, and real-time VM analytics make it easy to monitor SLAs while investing minimum IT administration time.

Optimize Your Investment

DVX always-on data efficiency compresses and deduplicates your data before it’s saved to host flash, so you can reduce costs and keep your entire data set close to your application. Protection Groups with VSS on converged primary and secondary storage gives administrators fast access to recover, clone, and manage previous copies without the extra cost of a separate backup system.

HOW IT WORKS

Microsoft SQL Server Apps Running on DVX

Always-On Availability Groups

For Microsoft SQL Servers deployed with Always-On Availability Groups (AOAGs), each DVX host server that has your Availability Replicas keeps the same deduplicated and compressed data in its local flash. If your primary SQL Server fails, your secondary replica on another DVX host will immediately take over and provide the same level of performance.

SQL Server Backup

For data protection, you can use SQL Server native backups to an SMB share on a Windows VM. Once your data is safely inside the VM, you can use DVX built-in data protection to make space-efficient, consistent point-in-time copies for instant recovery and cloning purposes.

Protection Groups with VSS Provider

Customers can create application-consistent snapshots using Automatrix Protection Groups and the Datrium VSS provider with zero VM stun and only seconds of application impact. This functionality allows SQL Server administrators to instantly rollback to the most recent good backup in a disaster or ransomware recovery situation.

Multi-Site Protection

Your AOAG protection groups are automatically protected offsite with Automatrix Elastic Replication based on your policy settings. Datrium ControlShift provides DR orchestration between sites with compliance checks every 30 minutes. If you use cloud DR, Datrium DRaaS with VMware Cloud on AWS delivers an on-demand SDDC to reduce your DR costs by 10x.

SQL Server Restore and Clone

Restoring or cloning your SQL Server is simple with Automatrix VM-centric management. Administrators simply power off the VM, restore the VM or vDisk from the local DVX system, and power on for instant restart. Creating a copy of your production database for development or test purposes is also easy by cloning the VM, adding it to the hypervisor inventory, and powering it on.

PRODUCTS

DVX

The foundation for world-class Microsoft SQL Server performance, availability, and security.

ControlShift

Failproof DR with instant RTO and one-click failover and failback between data centers.

DRaaS

On-demand DR with VMware Cloud on AWS delivers 10x lower costs.