Only receive emails for the most important alerts
CONTEXT: I review alerts raised by SQL Monitor in order to stay on top of my server activity, and I also have alert emails enabled in order to respond quickly to issues.
PROBLEM: I only want to receive emails for issues that require immedate action or are otherwise noteworthy. I don't want to change the alert thresholds because for my triage, the "lower-priority" alerts are still interesting - but they shouldn't be sent as emails.
EXAMPLE SOLUTIONS:
• Send emails by alert priority - e.g. medium and high only
• Alter the default alert behaviour to only send emails for high-priority alert types
• Send emails for "new" alerts - such as a long-running query that hasn't been encountered before - but don't email about repeat offenders
• implement an alternative triage view that lists significant events that happened on my servers independently of alerts getting raised - this way we can set higher alert thresholds without losing information.
What do you think about these solutions? Got another idea? Let us know in the comments!
We have released version 9.0.10 of SQL Monitor which includes the ability to choose to receive notifications for only high level alerts, or only high and medium alerts (or the default of all severities) globally.
https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notes
We realise this is long overdue, as we’ve struggled to provide one solution to the different problems contained in this suggestion. As such, we’ve decided to break this down into different problems we can look to address.
We believe this release delivers the solution to the problem originally suggested, to be able to send email notifications for alerts with a Medium or High priority, so will mark this as completed. However, please do raise new suggestions for anything you feel hasn’t been addressed by this release, so we are able to consider each one as we continue to improve SQL Monitor.
Thank you for your patience,
SQL Monitor Development Team
-
Daniel Watkins commented
i.e. only send an email for alerts with a Medium or High priority.