Forum Discussion

Brass Contributor

Feb 20, 2018

Solved

create a search query for the Average of CPU over 15 mins .. and set alert to it

Hi all I am trying to create some monitoring based on OMS Queries one of the them is creating an alert if the average CPU Utilization over 15 mins was more than 90% .. when i use this q...

Azure Log Analytics

azure monitor

Stanislav_Zhelyazkov

MVP

Jul 12, 2018

Hi,

I am not quite sure what you want to achieve. If I understand correctly may be this:

Perf
| where  ObjectName == "Processor Information" and CounterName == "% Processor Time" and InstanceName == "_Total"
| summarize AggregatedValue = avg(CounterValue) by Computer, bin(TimeGenerated, 15m)
| where AggregatedValue > 90
| render table

You can also render timechart but the visualization will not be pretty as it will show only periods where the machines were above 90. Because such visualization is not pretty I am not sure if this is thing you want to achieve.

RCDevops777

Copper Contributor

Mar 07, 2019

Hi Stanislav,

We are using the ObjectName == "Processor" for this query, hope it is the same ?

Perf
| where  ObjectName == "Processor Information" and CounterName == "% Processor Time" and InstanceName == "_Total"
| summarize AggregatedValue = avg(CounterValue) by Computer, bin(TimeGenerated, 15m)
| where AggregatedValue > 90
| render table