Support for showing multiple metrics with the same units on Analysis Graph
When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x axis - and I get that - it makes sense when the units are incompatible (eg. percentage vs KB used vs batch/sec).
But when all the metrics are measure in the same units, it can create a visually confusing graph.
For example I'm looking at memory usage over time, so I've chosen Machine: memory used, SQL Server: total memory, SQL Server: target memory. On the face of it, it looks like SQL Server is using way more than target memory, and in fact more than the entire machine is using!! Only when you mouse over the graph and get the values do you see that the total memory is in fact just under target memory and fairly well below machine memory.
So I'd like it if the graph was more intelligent about this, and shared the x axis when it could. Not sure how you can handle this if there are a mixture of compatible and non-compatible metrics, but you've got some good UXers there who can bash this around!
(also discussed on the forums : https://forum.red-gate.com/discussion/comment/148065)
kevriley
shared this idea
-
Anonymous
commented
Create simple graph with Compilations/sec and Batch request/sec you will get an incorrect and confusing graph! Please, consider this!
-
Steven K. Mariner
commented
Even better (more work for you to implement, naturally) would be an option to force the graph to the same scale (in my case, it's the vertical component, or Y axis). That way we can still get the scaled-comparison graph as well as the raw-values comparative graph.
Thanks for considering this option!