In many situations, we alert if a monitor has gone down for a certain length of time - say 5 minutes. In the event an application is going down for a minute every other minute, something is definitely wrong, but I would never know it. It would be great to be able to alert if a monitor goes down 'x' times in 'y' minutes.
Something like an alert for application availability < 95% for 20 minutes. I just checked the alerts gui and it's not there sadness. You would need to do an Custom SQL alert to do it.
where APM_ApplicationAlertsData.ApplicationID in (
where [Timestamp] > dateadd(MINUTE,-10,GETUTCDATE())
group by ApplicationID
having AVG(PercentAvailability) < 95