New Relic

Average duration nrql

SELECT average(duration) FROM Transaction WHERE <params> Since 1 week ago TIMESERIES 1 hour FACET <param>

99th Percentile

SELECT percentile(duration,99) FROM Transaction WHERE <params> Since 1 week ago TIMESERIES 1 hour FACET <param>

Traffic Levels

SELECT count(*) FROM Transaction WHERE <params> Since 1 week ago TIMESERIES 1 hour FACET <param>

Percent of Errors (eg 500s)

SELECT percentage(count(*), WHERE httpResponseCode LIKE '5%%') FROM Transaction  SINCE 1 hour ago TIMESERIES FACET name