Monitoring a Database

aborders1

r2Is there a fairly easy way to monitor the status of a database (Online vs Offline) using the Server and Application Monitor? I think I may have to create a custom application monitor but am wondering if someone else has something already.

I have an application that fails about every two to three weeks. When it fails I find that the database is offline. The database server (SQL 2008 R2) is still fine though. I cannot find any reason in the server logs or the SQL logs for the DB to be offline. I would like to setup an alert when this happens so I can try and track it with little impact to my end users.

Thanks for any ideas.

Adam

aLTeReGo

The following SQL query below can be used to return the status of your database. Simpy replace "YourDatabaseName" with the name of the database you wish to monitor. I've actually taken the example below and created an application template that I've posted to the content exchange here on Thwack so you can easily import into SAM. It can be downloaded from here.

SELECT                 [state]                ,state_descFROM sys.databasesWHERE                Name = ‘YourDatabaseName’