Choose aggregation used in the analysis graphs
(Posting for a user)
Would it be possible to request a change to the graphing data algorithm to allow for the user to select (when adding a metric to the analysis graph) whether to use AVG (mean) aggregated or MAX aggregation. Although you could allow for any of the aggregation operators to be used, see screen mock up below from the SQL Monitor Analysis tab where you add the metrics to the graph.
I think it would significantly enhance the analysis of peak (local or global maximums) and it would prevent peak values being artificially dragged down to a local lower average. It would also allow users to take control of how to handle data points not shown on the analysis graphs.
Thanks for your time and consideration.
Kind Regards
Jonathan Butler
Chris (Tech Support)
shared this idea
Unfortunately this is a fundamental constraint of sampled data: The peaks you see in SQL Monitor are the result of spaced sampling as well, and are therefore (informartion-theoretically) no different from the average aggregation that you see when you zoom out in SQL Monitor.
We could make it so that when you zoom out, we show you the highest data point in our data set, ie. the highest partial average, but that’s not really mapping to anything real, so would be quite misleading
-
Stephen Bovill
commented
You can partly replicate the desired effect by having two tabs open and:
On the analysis page zooming to below 6 hours on the graph you want to see
On the other screen click the logout button
return to the analysis screen and zoom out, the data doesnt aggregate while you are logged out
(It does mean you only get a certain time frame of data but is really useful to see)on the other screen log back in then change zoom / move along the time to refresh and update the analysis graph
-
Stephen Bovill
commented
Firstly want to say that the aggregation works well for keeping most of the peaks / dips but there's been a few instance I've noticed where they get aggregated out,
if you zoom in / out quickly the aggregation setting doesn't change straight away and you can see the full graph at a level or two above / below the zoom you're currently at.
I'm requesting we get the option to control that to say yes I'm zoomed out but I would still like to see as much of the detail on this graph as possible.
Thanks for your time and consideration
Ste -
Thanks for the suggestion, this is a really interesting idea, and one I've heard before. I'll be interested to see if others would find this of value.
-
Traian C.
commented
I would like to extract the collected values over a bigger time period and not the calculated values like you get when you expand your timeframe while looking at the analysis metrics. I tried to do this for batch req/sec for 24hrs and export it to an excel file but, again, I get the calculated values and not the collected ones like that I need.
Here's a topic I found that reflects what I wanthttp://documentation.red-gate.com/pages/viewpage.action?pageId=20742985
Thanks!
