MOM, CheckDB, Suspect Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

MOM, CheckDB, Suspect Database

Author

Topic

RocketScientist
Official SQLTeam Chef

85 Posts

Posted - 2007-07-02 : 10:00:25

So I've got this vendor-supplied database for a third-party application. Let's just say the database name rhymes with "MQManage".

For some reason the vendor elected to set up the database with Auto Shrink turned on (eeww) and to set up a job that runs DBCC CHECKDB() every 15 minutes (eeww). I'm working on resolving both of those issues right now. In the meantime, I'm getting sporadic messages from Microsoft Operations Manager (MOM) telling me that the database is suspect. The really odd thing is that there is nothing in the SQL Server error log, Windows event log, or anywhere I can find that says the database went suspect. The database isn't suspect, and there was no operator intervention.

So something is causing MOM to get a false positive here. Just on this one database on this one server.

Thoughts?

Kristen
Test

22859 Posts

Posted - 2007-07-02 : 10:35:13

use perfMon to trace what MOM is querying the database with. That might lead to what is causing it to think the DB is hosed. Might just be blocking whilst the Shrink is running ...

A database with its own Shrink, now that's something else