You have an instance of SQL Server on Azure Virtual Machine named SQL1.
You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort.
Where should you store the metrics?
a Log Analytics workspace
Azure Event Hubs
Azure SQL Database
an Azure Blob storage container
Submit