Integrity check overdue Alert Not Updating Post DBCC CHECKDB

SQL Server performance monitoring and alerting

Integrity check overdue Alert Not Updating Post DBCC CHECKDB

Postby EdCarden » Wed Feb 12, 2014 7:12 pm

I have a number of Integrity check overdue alerts that are showing ACTIVE even after I have verified that the DBCC CHECKDB (WITH TABLERESULTS) has been excuted and it was executed over an hour ago.

Based on my understanding of this ALERT it should be checked by SQL MOnitor continously at least often enough that after CHECKDB has been run the status of the ALERT should have been changed at least within an hour if not a few minutes.

Thoughts?

I'm running SQL Monitor 4.0.0.1728

Thanks
EdCarden
 
Posts: 90
Joined: Tue Nov 25, 2008 6:26 pm

Postby chriskelly » Fri Feb 14, 2014 12:31 pm

The database integrity check metric runs every 1 minute by default. It works by checking the dbi_dbccLastKnownGood date field to find out if the last run was sooner than the configured alert threshold.

So, on the limited information available I would guess that either:
- the dbi_dbccLastKnownGood has not been updated
- the default collection schedule has been changed
- the metric that is checking dbi_dbccLastKnownGood is timing out or returning null or out of date information.

Can you therefore send me the following information at support@red-gate.com quoting the ticket reference number #13147 in the subject line.
- The SQL Monitor error log files
https://documentation.red-gate.com/page ... d=20743048
- The Base Monitor configuration file
RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config
found here: C:\\ProgramData\\Red Gate\\SQL Monitor 4
- The result of this query
DBCC DBINFO (dbname)
[don't forget to edit the dbname]
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby EdCarden » Thu Mar 06, 2014 5:48 pm

@Chris Kelly,

Apolagies for not replying sooner but this is not a high priority issue but something I do want to resolve. When I run the DBCC command you provided I get nothing back save for the message that the DBCC completed and if it printed any errors then contact the sys admin (there were no errors). Is that what you were exoecting it to return or should there be more thant that message?
EdCarden
 
Posts: 90
Joined: Tue Nov 25, 2008 6:26 pm

Postby chriskelly » Thu Mar 06, 2014 5:57 pm

Please can you send the requested information, including the log files to support@red-gate.com unless you already have done so.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests