CODEWITHSUNDEEP
newrelicnrql
Paul
Paul

Reputation: 1

New Relic NRQL: comparing CPU usage between deployed EC2 instance types

I would like to know if anyone has any ideas on how to craft an NRQL query to compare CPU usage between various deployed AWS EC2 instance types. Any ideas?

Upvotes: 0

Views: 1287

Answers (1)

David Marchelya
David Marchelya

Reputation: 3432

If you are using New Relic Infrastructure, you should be able to use NRQL similar to this:

SELECT cpuPercent FROM SystemSample FACET ec2InstanceType TIMESERIES

Reference: Default Infrastructure attributes and events

Caveat: I have not used New Relic Infrastructure, and have not tested that query.

If you are not using New Relic Infrastructure, this does not appear to be supported via NRQL. See this related thread and response on the New Relic forum: Query servers CPU usage in New Relic

Right now I don't have any update about this feature coming to the Server Monitor product, but I know that the Infrastructure product that we currently have in beta, does push server data to Insights for use. - (Nov '16)

Also, if you don't need to use NRQL to craft the query, you can create a metric widget using the Metric Explorer that might meets your needs. See: Metric Explorer: Search and chart metrics sent by New Relic agents. Specifically the example: "Add metric widget for CPU usage faceted by host".

Upvotes: 0

Related Questions