Mixing metrics on analysis graph

Posté le : Samedi 07 Octobre 2017 9:51

HI,

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. In this 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.

Please help.

Thanks!

I did not find the right solution from the Internet.

References:https://forum.red-gate.com/discussion/81828/mixing-metrics-on-analysis-graph

Brand video ad