MSSQL Database in Suspect mode

[gselvakumar]

Hi team,
We are monitoring MSSQL Database.One of the requirement to monitor if a MSSQL database goes into suspect mode.Can anyone help me with this

[Box293]

I can't find anything on the Nagios exchange for this.

How do you detect if a database is in suspect mode? Is there a query you can perform?

[nietonoshana]

I can't find anything on the Nagios exchange for this.

How do you detect if a database is in suspect mode? Is there a query you can perform?

Yes, The Status in database is located in sys.databases

Can you use Wizard MSSQL Query and put there:

Code: Select all

SELECT count( state_desc) FROM master.sys.databases  where state_desc like 'SUSPECT'

know that a base entered in that State over not which

Or you can add a filter by the name of the base

Code: Select all

SELECT count( state_desc) FROM master.sys.databases  where state_desc like 'SUSPECT' and name like 'databasename' 

[Box293]

Excellent, those queries can be used with the wizard.

Run the MSSQL Query Wizard.
You will be able to add the query on Step 2 of the wizard.

Does this help?

[gselvakumar]

sorry for the delay in response
Thanks nietoshana and Box293.The above mentioned query is working.

[rkennedy]

Awesome! Are we good to mark this one as resolved?

[gselvakumar]

Yes .Once again thanks