When do alerts fire?

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

When do alerts fire?

Postby lrobbins » Tue Jan 29, 2013 3:14 pm

I am trying to determine when an alert is fired.

For example, I have an alert that was raised stating a database is overdue for a database integrity check. The alert was raised on 1/28 at 11 am. however, on 1/28 10:45pm a database integrity check was done on all the databases within the server and the alert hasn't ended.

when will this alert be fired again in order to change the status from active to ended?
lrobbins
 
Posts: 5
Joined: Thu Jan 03, 2013 10:31 pm
Location: United States

Postby chriskelly » Wed Jan 30, 2013 4:31 pm

The alert should change state to Ended once that SQL Monitor detects that an integrity check is younger than the threshold set in the alert configuration. This detection will happen the next time that the Base Monitor service runs the DBCC Info (it looks at the result for dbi_dbccLastKnownGood).

A quick test is to run the query described in the alert description and then check the above object (which is also described in the alert).
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest