Mike_Lemay
Nov 11, 2024Copper Contributor
Single pane of glass to look at all of my SQL Servers
I just got back from SQL Pass Summit 2024 and I was told that I could ARC enable all of my SQL Servers so I would have a single pane of glass to view and scan logs, configurations, view best practices etc. Unfortunately, when I got home, I realized that since we have SQL Servers on Azure VMs we can't use Azure ARC to manage them.
Unsupported configurations
Azure Arc-enabled SQL Server doesn't currently support the following configurations:
- ...
- Multiple instances of SQL Server installed on the same host operating system with the same instance name.
- SQL Server in Azure Virtual Machines.
- An Always On availability group where one or more replicas is on a failover cluster instance.
Since all our Azure VMs have the SQL Agent installed how can we unify our management experience in Azure?