In NewRelic Alerts, NRQL is limited based on the threshold value and the greatest threshold value supported by New Relic is 120 minutes( 2 hours). We wish to set alerts for a duration of 24 hours or even for custom time(say, 6.00-11:00 am) since the jobs run only once a day.
I have a metric called “events received” and I wish to check that the value for this metric is over 1000 in 24 hours. If it is less than 1000 , I need to trigger an alert for the same. However, because of the 2 hour limit I am unable to do so.
A workaround I was considering was to check the value for a specific time period, say between 6:00 am and 11:00 am , the value should be around 100 and more and if it less, an alert should be triggered.
The query that I used but do not get the expected results.
SELECT * from Metric where metricName = 'APP02438.prod.event_received' and EventType = 'WorkerChanged' and hourOf(timestamp) >= '6:00' and hourOf(timestamp) <= '11:00' SINCE 1 day ago
Moreover, as I will be using NRQL in alerts , I will not be able to use ‘SINCE’ to set a time range.
I’ve also reviewed New Relic Help Center and there’s requests to extend the Alert threshold beyond 2 hours. Unfortunately, I’m finding this was requested way back in 2015 and New Relic hasn’t addressed it yet.
does anyone have any ideas on how to circumvent this New Relic limitation?