Thank you Christian,
For now, assuming I don't/can't fix the labels, this should give me
CPU usage > 90% on "non-SQL servers" (by hostname convention)
+-------------- percentage of time the machine is idle
--------------+
|
|
v
v
((100 - (avg by (instance) (irate(wmi_cpu_time_total{mode="idle"}[5m])) *
100)) > 90) and on(instance) wmi_cs_hostname{hostname!~".*SQL.*"}
^^
^ ^ ^ ^
||
| | | |
|+--------------------- percentage of time the machine is not idlea
----------+ | | |
|
| | |
+--------------- percentage of time the machine is above 90% utilization
----------+ and +---- hostname NOT an SQL server ---------------+
On Thursday, December 17, 2020 at 5:58:21 PM UTC-5 Christian Hoffmann wrote:
> Hi,
>
> On 2020-12-17 23:06, Alan Miller wrote:
> > The problem is that my "instance" fields are IP address:port (eg:
> > 10.123.5.5:9182).
> The best solution would be to fix exactly this. ;)
> https://www.robustperception.io/controlling-the-instance-label
>
> > So this query returns the instances and what looks like % cpu
> utilization:
> > ( 100 - (avg by (instance)
> > (irate(windows_cpu_time_total{mode="idle"}[5m])) * 100) > 95)
> >
> > And this query gets me the hostnames I'm looking for:
> > windows_cs_hostname{hostname=~".*as.*"}
> >
> > So how do I combine them so that I get the CPU utilization value for
> > ONLY hostnames
> > starting with "as" (here again, the instance fields are the same
> > ipaddress:port pairs.
>
>
> Try something like:
>
> ( 100 - (avg by (instance)
> > (irate(windows_cpu_time_total{mode="idle"}[5m])) * 100) > 95) and
> on(instance) windows_cs_hostname{hostname=~".*as.*"}
>
>
> Kind regards,
> Christian
>
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/e6ddc0f3-253f-456f-a28a-a2d33092c527n%40googlegroups.com.
