We've installed SQL Monitor 2.2 and would like to request better alert window settings.
One example:
We regularly create copies of some, not all, of our production databases on multiple instances. The restores of these copies cause multiple alerts to fire; database unavailable, transaction log backup over due, etc.
The timing and expected duration of these restores are known.
We would like to be able, at the database level, to set the alerts to not fire during these recurring activities.
So
1) Maintenance window at the database level
2) recurring windows: Daily, Weekly, etc
One example:
We regularly create copies of some, not all, of our production databases on multiple instances. The restores of these copies cause multiple alerts to fire; database unavailable, transaction log backup over due, etc.
The timing and expected duration of these restores are known.
We would like to be able, at the database level, to set the alerts to not fire during these recurring activities.
So
1) Maintenance window at the database level
2) recurring windows: Daily, Weekly, etc