Hi! I’m noticing very different SPL and thus different performance between the NMON Summary Light Analysis dashboard, the Top 20 processes CPU Statistics panel specifically, vs the NMON Analyser LINUX dashboard, Process, Kernel, I/O Statistics, Top, CPU Usage per logical core. When I compare the 2 dashboards, in terms of results, they look identical to me. But the performance isn’t the same – the one from the Light Analysis is about 4 times slower. I am wondering why and if it’s normal. Check it out: From NMON Summary Light Analysis: SPL: | mstats max(_value) as value where `nmon_metrics_index` metric_name="os.unix.nmon.processes.top.pct_CPU" host=myhostby host, metric_name, dimension_Command, dimension_PID span=1m
| stats sum(value) as pct_CPU by _time, host, metric_name, dimension_Command
| appendcols [ | mstats latest(_value) as logical_cpus where `nmon_metrics_index` metric_name="os.unix.nmon.cpu.cpu_all.logical_cpus" host=myhost by host ]
| appendcols [ | mstats latest(_value) as virtual_cpus where `nmon_metrics_index` metric_name="os.unix.nmon.cpu.cpu_all.virtual_cpus" host=myhost by host ]
| filldown logical_cpus, virtual_cpus
| stats values(pct_CPU) as pct_CPU, values(logical_cpus) as logical_cpus, values(virtual_cpus) as virtual_cpus by _time, host, dimension_Command
| eval usage_per_core=(pct_CPU/100), smt_threads=(logical_cpus/virtual_cpus)
| eval usage_per_core=case(isnum(smt_threads) AND smt_threads>="2", usage_per_core*1.2, isnum(smt_threads) AND smt_threads>="4", usage_per_core*1.4, isnum(usage_per_core), usage_per_core)
| timechart `nmon_span` useother=f limit="20" max(usage_per_core) as "CPU Usage per core" by dimension_Command Runtime: This search has completed and has returned 364 results by scanning 533,512 events in 3.937 seconds And from NMON Analyser Linux Dashboard SPL | mstats max(_value) as value where `nmon_metrics_index` metric_name="os.unix.nmon.processes.top.pct_CPU" host="myhost" by dimension_Command dimension_PID span=1m
| stats sum(value) as pct_CPU by _time, dimension_Command
| eval usage_per_core=(pct_CPU/100)
| timechart `nmon_span` useother=f limit="50" max(usage_per_core) as "CPU Usage per core" by dimension_Command Runtime: This search has completed and has returned 364 results by scanning 533,512 events in 1.36 seconds Again, identical results, but very different performance and different SPL – which is most likely the cause of the different performance. Thoughts? Thanks! @guilmxm
... View more