Question

You manage a pooled AVD host pool with 12 session hosts sending performance data to a Log Analytics workspace. Users report intermittent slowness in the afternoons. You need a KQL query that identifies which session hosts have the highest sustained processor pressure so you can rebalance load. Which query returns the average CPU utilization per session host over the last 24 hours, sorted from highest to lowest?

Accepted Answer

Perf | where ObjectName == "Processor" and CounterName == "% Processor Time" | where TimeGenerated > ago(24h) | summarize AvgCPU = avg(CounterValue) by Computer | sort by AvgCPU desc

Answer

WVDConnections | where TimeGenerated > ago(24h) | summarize count() by SessionHostName | sort by count_ desc

Answer

Perf | where CounterName == "Available MBytes" | summarize min(CounterValue) by Computer | sort by min_CounterValue asc

Answer

Heartbeat | where TimeGenerated > ago(24h) | summarize LastSeen = max(TimeGenerated) by Computer | sort by LastSeen desc