Dashboards, Alerts & NRQL

Dashboards

Dashboards are collections of widgets (charts) you add from metrics, NRQL, or curated views.

Assignment: create a dashboard similar to a host overview — CPU, memory, and network on one page.

Alerts

The goal of monitoring is that spikes notify people via call, SMS, Slack, or email.

1. Create an alert condition (for example high CPU)
2. Attach it to a policy
3. Add a notification channel (email, Slack, …)

What is NRQL?

NRQL (New Relic Query Language) is a SQL-like language for querying telemetry in New Relic — for custom charts and alert conditions.

CPU usage examples

Fetch average CPU over time:

SELECT average(cpuPercent) AS `CPU used %`
FROM SystemSample
WHERE entityGuid = 'YOUR_ENTITY_GUID'
TIMESERIES AUTO

Filter / compare multiple hosts with facets:

SELECT average(cpuPercent) AS `CPU used %`
FROM SystemSample
WHERE entityGuid IN ('guid-1', 'guid-2')
FACET entityGuid
TIMESERIES AUTO

Network example pattern:

SELECT
  average(transmitBytesPerSecond) AS `Transmit bytes/s`,
  average(receiveBytesPerSecond) AS `Receive bytes/s`
FROM SystemSample
WHERE entityGuid = 'YOUR_ENTITY_GUID'
TIMESERIES AUTO

Replace YOUR_ENTITY_GUID with the GUID from your host entity page.