I would like to know how to set up an alert message if the response time for a particular transaction going above > 8 secs via NRQL in New relic and i need a query to fetch a particular transaction response time is going above 8 seconds
Hi @anar1 welcome to the community Let me see if I can get @philweber or @stefan_garnham to provide some insights on how you might be able to accomplish this. Thanks for being patient with getting a response
Hi @anar1 - The query you need will be:
SELECT count(*) FROM Transaction WHERE name = '[transaction name you want to monitor]' AND duration > 8
Set the condition to fire when results > 0
May want to add an
AND appName = 'Your Application', in case you have more than one application with the same transaction name.