You have an Azure subscription that contains the following resources:
• 10 Azure SQL databases
• Five Azure SQL managed instances
• Five instances of SQL Server on Azure Virtual Machines
You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort.
What should you include in the solution?
To implement a centralized monitoring solution for all Azure SQL resources, including Azure SQL databases, Azure SQL managed instances, and SQL Server on Azure Virtual Machines, SQL Insights is the appropriate choice. It provides comprehensive monitoring across all these different types of SQL resources, thus minimizing administrative effort by having a unified monitoring solution.
Answer is D. SQL Insights is the only option that monitors SQL Server on Azure VM, Azure SQL Database and Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql
yes you are right, VMs are not supported by SQL Analytics