I have SQL installed on Azure VM , which is connected to Log Analytics workspace, for logging/monitoring.
Using Azure Monitor , We want to raise alerts based on the buffer cache hit ratio of SQL Server on Azure VM.
Can you please help with same query for the same