I want to add an alert for a service, similar to an “APM Application Metric” alert with “When target application Throughput (web) has a call count above…” However, I want to count transactions on only one endpoint.
How can I do this?
I tried creating a NRQL alert that counts the transactions for this endpoint. However, I’m not sure how to slice the time for the threshold. So, I created a NRQL similar to the following:
SELECT count(*) FROM Transaction WHERE appName = ‘MayApp’ and name = ‘WebTransaction/Something/endpoint’
(I’m new to NRQL and alerts.)
I could set up the alert condition as “When the query returns a value above 100 for at least 10 minutes”. However, the NRQL query does not set a range within which it is counting transactions. If there were 10 transactions per minute, what will it compare to the threshold of 100, the count per minute (1)? the count per hour (600)? Do I just need to add something to the NRQL to make this work? Or am I approaching it completely wrong?