Microsoft Azure Arc-enabled SQL Managed Instance makes it easier for database administrators to manage on-premises SQL Server workloads in a hybrid and multicloud deployment model. This paper demonstrates the power and capability of the Dell PowerStore and PowerEdge products, combined with Arc-enabled SQL MI including contained availability group, to deliver a high availability DBaaS solution.
Unlike many performance studies, this workload was run on a very common hardware configuration. The PowerEdge servers with Intel® Xeon® Gold processors and 256GB DD4-DRAM are an affordable configuration with room to grow.
Throughout this study we have demonstrated exceptional performance, simplified and accelerated deployment, and predictable scale. Benefits include:
- Deploy entire database environments, including Always On Group environments (with separate copies of each database), in as little as two to three minutes.
- 15% performance improvement when comparing an Arc-enabled SQL Managed Instance Business Critical vs. a SQL Server 2019, Windows, and VMware ESXi configuration.
- 60 Seconds to deploy an Arc-enabled SQL Managed Instance Business Critical environment with HA capability.
- Leverage existing SQL Server skill experience, as this is the same SQL engine.
- Remove the burden of selecting and balancing RAID levels with the data redundancy feature provided by the PowerStore Dynamic Resiliency Engine.
- Easily move data between traditional SQL Server instances and an Arc-enabled SQL MI with PowerStore’s multiprotocol file access capabilities.
- Flexible storage system that provides a single architecture unified (block and file) or block optimized workloads to support a wide variety of traditional and modern workloads.
- No tuning required. Performant “out of the box” with default settings.
The combination of Arc-enabled SQL MI and a Dell Technologies infrastructure foundation helps ease and accelerate SQL Server data estate modernization strategies in a hybrid and multicloud world.