I’d like to use Insights to monitor our Microsoft Azure auto-scaling rules, and I’ve written a tool that creates a custom Insights event whenever one of our Azure webapps scales up or down.
I’m trying to use NRQL to plot a timeseries graph with the number of instances a particular webapp is using over time. The data looks roughly like this:
timestamp appName newInstanceCount scaleDirection 00:10 site1 2 ScaleUp 00:15 site2 4 ScaleDown 04:00 site1 3 ScaleUp 05:00 site1 2 ScaleDown
I’m using a NRQL query like
SELECT max(newInstanceCount) FROM AutoScaleAction SINCE 1 DAY AGO WHERE appName = 'site1' TIMESERIES AUTO to render a line chart with the value of
newInstanceCount over time.
The problem I’m running into is that when using TIMESERIES, periods during which there is no data are rendered as zero on the graph. Since I only insert an event when the value of
newInstanceCount changes, the line drops to zero between 00:10 and 04:00. I’d like the line chart to display the last-known value for periods where there is no data, rather than zero.
I’ve looked at the NRQL reference but I can’t seem to figure out a way to graph the data the way I want – Is this sort of scenario supported? What am I doing wrong here?
New Relic Edit
- I want this too
- I have more info to share (reply below)
- I have a solution for this
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.