We are experiencing connection drop outs from our application to our database. This is intermittent.
I have looked at trying to use an NRQL query to monitor this but I cant come up with one that monitors this.
I can use NRQL queries to see transaction times from the app to the DB, transactions longer than X amount of time and DB operations by slowest query time.
So, Ideally something that monitors the connection and it if drops to 0 for a period of time we get an alert is what I need.
The DB uses MySql and is built in AWS
Has anyone used a query for this before or can NR support help?