Updated: October 9, 2023 (October 9, 2023)

Using Azure Arc for SQL Server Management

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

Azure Arc offers a single management point for SQL Server across cloud and on-premises installations.
It can simplify management and help consistently enforce security rules and other kinds of policies.
Arc enables hourly rental of SQL Server on-premises, optimizing cost for infrequently run workloads and load testing.
Using Arc-enabled SQL Server requires highly privileged software agents and other infrastructure that can increase cost and risk.
Some features require Software Assurance or Azure components that raise ongoing costs.

Azure Arc for SQL Server helps customers use Azure management tools and services to centrally manage SQL Server deployments, whether they are on-premises, in Azure, or in other clouds, such as AWS or Google Cloud Platform (GCP). The toolset leverages numerous Azure features originally designed for Azure SQL services. The toolset can help simplify the management of a diverse mix of deployment, reduce risk, and ensure that SQL Server farms comply with requirements such as timely patching and offsite backups. However, Arc requires local agents running with administrative control, occasional connectivity to Azure, and other Azure services that add cost and risk.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now