There are CPU examples - you can launch from the portal, like this one:
I'm not sure I'd decommission a server based on just low CPU use.
I'd amend the query like this (you can also replace "avg" with "max" ). I added in a filter for < 10% only (you can use 2%) and a filter for machines that names start with "A" as I have a lot of servers :)
// CPU usage trends over the last day
// Calculate CPU usage patterns across all computers, chart by percentiles
| where Computer startswith "A"
| where ObjectName == "Processor" and CounterName == "% Processor Time" and InstanceName == "_Total"
| where CounterValue < 10
| summarize avg(CounterValue) by bin(TimeGenerated, 1h) , Computer
| render timechart
e.g. Computers less than 2% in past 31days - none of which I'd decommission as they are low use, and I know why.
Best Response confirmed by
Lucas Chies (New Contributor)
I'll follow your points, I'm also have a lot of VMs and many teams here, some times, estimates an big VM for one little service consumption and this will help to view what's the VMs and I can use with evidence to resize or decommission those VM.