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?

  • petevern's avatar
    petevern
    Brass Contributor

    Hi,

    Have you considered using the SQL Server IaaS extension under the SQL Server configuration of your VMs? This tool provides a centralized view of all your VMs running SQL Server.

     

Resources