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.
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
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.
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.