Database response time query

Hello all and a happy new year :slight_smile:
Question - I’d like to setup a NRQL query to show me database response time faceted by DB name.
I can do this with metrics per each service db, I want to have a dashboard where I can see anomalies in databases response time.
Would appreciate any guidance here…
Cheers,
Lior

Something like this?

FROM Metric
  SELECT average(apm.service.datastore.operation.duration)
  WHERE appName LIKE '%'
  FACET table
  TIMESERIES MAX
  LIMIT 6

To track the slowest 6 database response times by table name. You can explore metric timeslice data in more detail in the docs.

2 Likes

Exactly like this @rishav.dhar :slight_smile:
Thank you from the bottom of my heart :slight_smile:

Cheers,
Lior

1 Like

I love it when two of our favorites meet up and make New Relic magic happen! Many thanks to you both.

1 Like