Page 1 of 1
MSSQL Database in Suspect mode
Posted: Fri Jul 01, 2016 2:08 am
by 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
Re: MSSQL Database in Suspect mode
Posted: Mon Jul 04, 2016 1:16 am
by 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?
Re: MSSQL Database in Suspect mode
Posted: Mon Jul 04, 2016 4:53 pm
by nietonoshana
Box293 wrote: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'
Re: MSSQL Database in Suspect mode
Posted: Mon Jul 04, 2016 8:48 pm
by 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?
Re: MSSQL Database in Suspect mode
Posted: Thu Jul 14, 2016 2:29 am
by gselvakumar
sorry for the delay in response
Thanks nietoshana and Box293.The above mentioned query is working.
Re: MSSQL Database in Suspect mode
Posted: Thu Jul 14, 2016 9:27 am
by rkennedy
Awesome! Are we good to mark this one as resolved?
Re: MSSQL Database in Suspect mode
Posted: Fri Jul 15, 2016 12:34 am
by gselvakumar
Yes .Once again thanks