Forum Discussion

Mike_Lemay's avatar
Mike_Lemay
Copper Contributor
Nov 11, 2024

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?

No RepliesBe the first to reply