integrity due alert

SQL Server performance monitoring and alerting

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

integrity due alert

Postby xdai » Tue Jan 29, 2013 4:49 pm

Hi,

I am wondering why we get alerts on integrity due on msdb and model db, when dbi_dbccLastKnownGood date field is greater than the 7 days we specify? For example, we have the job start at 2 am, and the model and msdb dbi_dbccLastKnownGood is 02:01:55.707, but we got alert. However, the master db dbi_dbccLastKnownGood field is 05:00:11.323 (all three databases run integrity check at the same job), but the job finish in less than an hour about 3 am. So why master's dbi_dbccLastKnownGood is 05:00:11.323? How does this field get updated?

thanks
xdai
 
Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm

Postby chriskelly » Wed Jan 30, 2013 9:16 pm

The alert is generated based on the content of the dbi_dbccLastKnownGood at the time that it checks it (SQL Monitor has a complex polling schedule). This value is populated and maintained by SQL Server itself, SQL Monitor only reads it.

However, I am not sure what you are asking. Are you experiencing an error?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby xdai » Wed Jan 30, 2013 9:21 pm

Yes. the integrity check job start at 2am, and the model and msdb dbi_dbccLastKnownGood field both are 02:01:55.707, and the job completed successfully. but why we still got alert about the due for model and msdb?
xdai
 
Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests