May 12 2020
12:42 AM
- last edited on
Apr 08 2022
10:26 AM
by
TechCommunityAP
May 12 2020
12:42 AM
- last edited on
Apr 08 2022
10:26 AM
by
TechCommunityAP
I am trying to use below query to find memory utilisation percentage, when i am trying to use summarize operator with division operator to get percentage its giving me output as zero only.
Can someone help please
May 12 2020 11:33 AM
Please try this (I have also replaced contains with has - as per best practise, also you can remove the two extra columns I added if its working ok?)
InsightsMetrics
| where TimeGenerated > ago(1h)
| where Namespace has "Memory"
| where Name has "AvailableMB"
| extend FreeMB = toreal(32000-toint(Val))
| extend totalMB = toreal(Val) + toint(FreeMB)
| summarize percent = max(FreeMB/totalMB)*100, max(FreeMB), max(totalMB) by bin(TimeGenerated, 5m)