For the most recent release of SQL Monitor, version 3.4, we’ve focused on making further improvements to the Analysis feature. The previous release, version 3.3, introduced the ability to add multiple metrics for comparison, to make it easier to see correlations and aberrations. Having identified interesting peaks and troughs, we now want to help answer the question, “Is this normal?”, so we’ve made it easier to select customisable time ranges.
It can be useful to see how the metric looked at a previous time, the same time on a previous day or week for example, to establish if this is a pattern that repeats itself or is an anomaly. As well as adding more sensible defaults, we’ve made the comparison feature fully customisable (you can try this out on the live demo) and the time ranges more visible.
We encountered unimagined complexity with this feature and it seemed whenever we were satisfied with a solution, we’d run into another edge case that would break it. After much head scratching, sketching and coffee drinking, we think the new customisation is a significant improvement on the previous version, but we’d still like to know how you think we could improve it further.
We’ve also made the analysis graph navigation more interactive, so it is now possible to quickly drag the graph and easily zoom in and out.
Panning – using a mouse, click and hold, then drag the graph, or use the panning buttons at each end of the graph.
Zooming – to zoom the graph, position the cursor and then use the mouse scroll wheel or double click or use two fingers vertically on the touchpad.
In parallel with this, we’ve continued to make improvements to the performance of the feature so that the graph is more responsive. However, the Analysis page may be slow if you’re using Internet Explorer 7 and 8, so we recommend using Chrome or other browsers, or updating Internet Explorer.
We’ve also fixed the persistance of the selections, so you can navigate away from Analysis and when you return, the settings will have remained. We know that troubleshooting involves a lot of back and forth, so this should make it a smoother experience.
In a word, baselines. We’re currently developing a feature that will show baseline(s) for a metric, as we continue to focus on helping answer the question “Is this normal?”
We’re intending to release this very soon, but if you’d like to take a sneak preview then email us and we’ll get back to you…