Set up an alert message if the response time for a particular transaction going above > 8 secs

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 :slight_smile: 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

1 Like

May want to add an AND appName = 'Your Application', in case you have more than one application with the same transaction name. :slight_smile:

1 Like