When SQL Response detects a problem on a server, it raises an alert. This alert contains a summary of the problem and information about the state of the system when the alert was generated. The alert will always appear in the main user interface, but you can also choose, on an alert by alert basis, to be notified via email.
In any monitoring tool there’s a fine line between alerting too often and not enough. In V1, to try and avoid bombarding you with too many alerts, we came up with the concept of ‘occurrences’. Once SQL Response v1 raises an alert, that alert is not re-raised, even if the same problem is detected again, until the alert has been cleared. Instead, the number of occurrences of that alert is incremented by one. The main problem with this approach is that if you have not cleared the original alert you cannot receive another notification of the alert.
In V2 we are considering abandoning the concept of occurrences; instead SQL Response will create a new alert each time a problem occurs. We could potentially go one step further and allow multiple reminder emails, say every 10 minutes, to be sent until the problem has been acknowledged or resolved.
Something else we are considering implementing are alert digest emails. These would send you hourly, daily or weekly reports of all the alerts that had happened during that period. For example, you could potentially opt to be sent only a single email once an hour summarizing all the minor alerts that had happened during that hour, rather than receive a separate email each and every time an alert is raised. Digest emails could be used instead of, or alongside, regular email notification.
How do you prefer to be notified about the alerts raised by your monitoring tool? Do you prefer using the main interface of the actual monitoring application, or do you rely on emails? What notification process do you have set up for out of hours alerts?
We’re very keen to hear about how you’re currently notified about problems, and also, in an ideal world, what your notification process would be (if the two are different!). The more you tell us, the more able we’ll be to develop something that caters for your needs.