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.
Solved! Go to Solution.
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.
Name = ‘YourDatabaseName’
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.