New training: Streamlining alerts in SQL Monitor. Watch now.

Mixing metrics on analysis graph

kevrileykevriley Preston, UKPosts: 129 Gold 1
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.


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!


Sign In or Register to comment.