topic Re: Get processes consuming CPU% based on high disk read bytes? in Dashboarding

Get processes consuming CPU% based on high disk read bytes?

Naveen — Mon, 06 Nov 2023 11:45:44 GMT

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

Re: Get processes consuming CPU% based on high disk read bytes?

radek_jasinski — Mon, 06 Nov 2023 11:53:32 GMT

Hi,

If I'm not mistaken the builtin:host.disk.readOps metric can only be spliced after Host or Disk.

Radek

Re: Get processes consuming CPU% based on high disk read bytes?

Naveen — Mon, 06 Nov 2023 11:55:43 GMT

Hey @radek_jasinski Yes but I need process data which were consuming more CPU when there are high readops.

Re: Get processes consuming CPU% based on high disk read bytes?

radek_jasinski — Mon, 06 Nov 2023 12:19:08 GMT

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

Re: Get processes consuming CPU% based on high disk read bytes?

Naveen — Mon, 06 Nov 2023 12:29:32 GMT

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)

Re: Get processes consuming CPU% based on high disk read bytes?

radek_jasinski — Mon, 06 Nov 2023 13:26:22 GMT

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