Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Database down alerts

Hi All,

We would like to monitor database instance down using Solarwinds SAM. What is the best practice to follow to configure this and alert in Solarwinds.

Appreciate your help in advance.

Best Regards

Find more posts tagged with

Accepted answers

All comments

Seashore

For starters you can just monitor the windows service for SQL. See if that one is up and running. Second you can ask a simple SQL query to see that you get a response. I have a template called "SQL Server Basics" to check just that.

The query in the "response test" I use look like this:

Declare @nr int
Declare @mess varchar(30)

select
@nr=count(*)
,@Mess = 'Number of databases online'
FROM
sys.databases
where state=0

Select @nr, cast(@nr as varchar(3)) + ' databases online'

Then create some basic alerts for that.
Hope that can be an inspiration for you!

Hi Seashore,

Thanks for your inputs and suggestion.