Drop markers on the graphs and add annotations
While working on performance tweaks it is customary to consult the analysis reports on a regular basis to see if our changes moved the needle. More often than not the tweaks are released one small batch at a time and it'd be nice to drop markers and custom annotations directly on the charts. I'd like to use that feature to add short phrases describing what was changed that led to the improvement, or degradation for that matter, of performance.
This would be by server (cluster/node) and by metric with the same retention period as the base data for that chart.
This will help us with analysis immensely.
Luke MacDonald commented
I have used LogicMonitor and it has this feature. It pretty much became a requirement when making changes to SQL server, that we annotate. It was super helpful.
Dave Jenkins commented
I'm using version 7.1 and I really could do with this feature going forwards.
Either need to be able to add comments onto the graph to explain what happened at that point. Also if there was an alert at that time maybe it could pull the comments that i added to the alerts.
It would be pretty cool if we could add notes to a spot on the graph. For example we copied a large file to one of our drives earlier this month and it shows on the graph as a large increase. Being able to add a note (even something similar to the comments for alerts) that corresponds with a point on the graph would be helpful for communication and logging.
Thanks Jamie. This is really good idea.
Jamie Bright commented
Ability to add a comment to a specific spike point in a graph so other DBAs (or yourself for reference) know what may have caused it, if looking historically.
i.e disk space available took a massive hit at 3pm, you may want to note that's when you made an ad-hoc backup - which when looking, co-workers will know that's what caused the graph to change.