Costa Rica
Last updated: 2025-07-17
Table of Wiki (Click to expand)
- Overview - SQL Server enabled by Azure Arc
- Benefit from Azure Arc-enabled SQL Managed Instance
- Public preview: Bring enhanced manageability to your SQL Server
- Best practices assessment for Azure Arc Enabled SQL Server
- Prerequisites - SQL Server enabled by Azure Arc
- Understanding Azure Arc Enabled SQL Server
- Plan and deploy Azure Arc-enabled servers - Azure Arc
- SQL Managed Instance enabled by Azure Arc Overview
- Analyze metrics with Azure Monitor metrics explorer
- Administer SQL Server with Azure Arc - Azure Architecture Center
- SQL Server enabled by Azure Arc
Once Azure Arc is connected, you can manage your SQL Server instances from the Azure portal, allowing you to view detailed inventory, run cross-SQL Server queries, and optimize configurations based on best practices
| Component | Description |
|---|---|
| SQL Assets | SQL Server instances enabled by Azure Arc, located on-premises, in multi-cloud, or at the edge. |
| Arc-enabled Data Services | Services that connect and manage the SQL Server instances, including automated backups, security updates, and monitoring. |
| Arc SQL Extension | - Windows Local Package: Package installed on Windows SQL Server instances for connectivity and management. - Linux Local Package: Package installed on Linux SQL Server instances for connectivity and management. |
| Arc Agent: Connected Machine Agent | Agent facilitating communication between SQL Server instances and Azure. |
| Enterprise Firewall and Proxy | Outbound Only on Port 443: Ensures secure outbound communication from on-premises to Azure using port 443. |
| Control Plane | Managed by Azure Resource Manager (ARM) and includes Microsoft Entra Identity for authentication. |
| Hybrid Connections | Managed through Microsoft Entra ID/Service Principal for secure connections. |
| Azure Resource Manager (ARM) | Manages resources across various environments using ARM templates or other methods. |
| Microsoft.AzureData Resource Provider | Manages data services enabled by Azure Arc, handling tasks like inventory management, billing, and licensing. |
| Environment | Description |
|---|---|
| On-Premises | You can connect your on-premises SQL Server instances to Azure Arc. This allows you to manage and monitor them through the Azure portal, providing a unified management experience. |
| Azure | Azure Arc can also be used with SQL Server instances running on Azure Virtual Machines (VMs). This extends the capabilities of Azure Arc to your cloud-based SQL Servers, enabling centralized management and governance. |
| Other Clouds | Azure Arc supports SQL Server instances running in other cloud environments, such as AWS or Google Cloud. This ensures you can manage your SQL Servers across different cloud providers from a single pane of glass. |
| AKS | Running SQL Server in Azure Kubernetes Service (AKS) allows for containerized deployment, scalability, resilience, and integration with other Azure services. This provides a robust, scalable, and flexible solution for managing SQL Server workloads. |
| Edge Locations | SQL Server instances running in edge locations, such as retail stores or remote offices, can be connected to Azure Arc. This allows for centralized management and monitoring of these distributed instances. |
| Azure VMware Solution | SQL Server instances running on Azure VMware Solution can also be managed through Azure Arc. This provides a consistent management experience for SQL Servers running in a VMware environment. |
| Azure Stack HCI | SQL Server instances running on Azure Stack HCI (Hyper-Converged Infrastructure) can be connected to Azure Arc. This enables hybrid cloud scenarios where you can manage on-premises resources alongside Azure resources. |
| Benefit | Description |
|---|---|
| Unified Management | Manage all SQL Server instances from a single point of control in the Azure portal, including on-premises, multi-cloud, and edge environments. |
| Enhanced Security | Use Microsoft Entra ID for authentication, providing enhanced security features like multifactor authentication (MFA) and single sign-on (SSO). |
| Consistent Updates and Patching | Receive frequent updates, including servicing patches and new features, ensuring SQL Server instances are always up-to-date with the latest enhancements. |
| Scalability and Flexibility | Deploy, manage, and monitor Azure SQL Managed Instance in various environments, including on-premises, edge locations, and public clouds using Kubernetes. |
| Cloud Benefits in Any Environment | Extend cloud benefits such as automated backups, high availability, and self-service provisioning to SQL Server instances, regardless of hosting location. |
| Improved Operational Insights | Gain comprehensive operational insights across all databases using tools like Azure Monitor, aiding in proactive management and troubleshooting. |
| Best Practices Assessment | Optimize the configuration of SQL Server instances for performance and security with best practices assessments offering specific recommendations. |
| Connectivity Modes | Supports both directly connected and indirectly connected modes, benefiting from most services even with intermittent or no internet connectivity. |
Refresh Date: 2025-07-18