Azure Monitor for VMs - Log Queries

[Jonathan Rossi]

Hi, I've installed Azure Monitor for VMs and I was under the impression we would need to change our existing Log Queries to stop using the Perf table for CPU/Disk/Memory/etc and start using some of the tables under the "Azure Monitor for VMs" group in Log Analytics (InsightsMetrics, etc.). However, looking at sample queries for CPU, disk, memory, etc., they all seem to still use the Perf table. Is that corect? We did not install the preview version of Azure Monitor for VMs. 

Can you share some examples where I would use the tables such as InsightsMetrics.

Thanks!

[#2]

@Jonathan Rossi 

Plenty of examples here:

https://docs.microsoft.com/en-us/azure/azure-monitor/insights/vminsights-alerts

Does that help ?

[#3 · Accepted solution]

@Jonathan Rossi you're right, there are 2 separate performance tables.

Perf is still the default table, it holds the performance counters you chose to collect (at the workspace level). The previous version of VM Insights used it as well. The new version of VM Insights now collects performance metrics into the InsightsMetrics table. The sample queries that you see for any VM resource, on its Logs page, use the Perf table, regardless of the VMInsights version you install.

If you're concerned about having both Perf and InsightsMetrics, read this FAQ entry.

The link provided on the first reply to your question (to sample alert queries) has the best examples to querying InsightsMetrics I could find.