Hi,
I want to see which processes were consuming high CPU when there were high Disk read bytes per second for specific host. Could you please help me writing the query.
Thanks
Solved! Go to Solution.
Hi,
If I'm not mistaken the builtin:host.disk.readOps metric can only be spliced after Host or Disk.
Radek
Hey @radek_jasinski Yes but I need process data which were consuming more CPU when there are high readops.
You have this metric available: builtin:tech.generic.io.bytesRead
"This metric provides statistics about the I/O read operations of a process. The metric value is a sum of I/O bytes read from the storage layer by all process workers per second. High values help to identify bottlenecks reducing process performance caused by the slow read speed of the storage device. It has a "Process" dimension (dt.entity.process_group_instance)."
It should meet your assumptions. On Data Explorer, you need to overlay two metrics (CPU and bytesRead)
https://docs.dynatrace.com/docs/shortlink/built-in-metrics#generic
Hi I have written below query, could you please evaluate
builtin:tech.generic.io.bytesRead:splitBy("dt.entity.process_group_instance"):sort(value(auto,descending)):limit(20)
builtin:host.cpu.usage:filter(and(or(in("dt.entity.host",entitySelector("type(host),entityName.equals(~"Host1~")"))))):splitBy():sort(value(auto,descending)):limit(20)
What I can suggest is to apply a filter on a specific process or host to improve the readability of the graph. Of course, you may prefer to have more data.
Example:
builtin:tech.generic.io.bytesRead:filter(and(or(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),entityName.equals(~"Apache Web Server easyTravel~")"))))):splitBy("dt.entity.process_group_instance"):sort(value(auto,descending)):limit(20)
builtin:host.cpu.usage:filter(and(or(in("dt.entity.host",entitySelector("type(host),entityName.equals(~"CF1-tomcatjms~")"))))):splitBy("dt.entity.host"):sort(value(auto,descending)):limit(20)
Radek