Hosts Memory Usage Overview Report

Scalyr Agent collects memory metrics from the hosts. For users who'd like to build a dashboard to monitor the memory used percentage of their hosts, they can apply the following JSON config to create a report. It basically calculates the memory used by subtracting the total memory of the host by the available memory.

{
   "graphStyle": "report",
   "query": "| join (metric ='proc.meminfo.memtotal' | columns value, serverHost | group total = avg(value) by serverHost),
                 (metric = 'proc.meminfo.memfree' | columns value, serverHost | group free = avg(value) by serverHost) on serverHost
             | let used = total - free | let pct_used = used/ total * 100 | sort -pct_used",
   "title": "Host Memory Usage Percentage"
}

The report of  memory usage percentage