Red Gate forums :: View topic - Integrity check overdue Alert Not Updating Post DBCC CHECKDB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Integrity check overdue Alert Not Updating Post DBCC CHECKDB

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Wed Feb 12, 2014 7:12 pm    Post subject: Integrity check overdue Alert Not Updating Post DBCC CHECKDB Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Fri Feb 14, 2014 12:31 pm    Post subject: Reply with quote

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/pages/viewpage.action?pageId=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
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Thu Mar 06, 2014 5:48 pm    Post subject: Reply with quote

@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?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Thu Mar 06, 2014 5:57 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group