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

SQL 2019 Cluster Failover

Hi,

Fairly new to Solarwinds SAM. We have one SQL Failover Cluster (3 nodes). We want to setup some type of email alert that will let us know when the cluster performs a failover. Can anyone point me to the best way to do this?

Thanks.

Find more posts tagged with

Accepted answers

All comments

adam.beedell

The easiest route is probably via an event log monitor against all 3

There's a SQL route but it's awkward if they dont agree with each other

You can poll the AG for hostname too but awkward to do stuff quickly off that

jm_sysadmin

I think the events live in: Microsoft-Windows-FailoverClustering/Operational and you want ID 1641
Powershell run on the SQL server can pull it with: Get-winEvent -ComputerName ListnerName -filterHashTable @ {logname ='Microsoft-Windows-FailoverClustering/Operational'; id=1641}| ft -AutoSize -Wrap

And if you prefer to get the data from SQL look at: How to monitor SQL Server failover events automatically (apexsql.com) and use that to be a SQL query monitor.

Personally, @adam.beedell suggestion to pull the event is the easiest.

adam.beedell

Thanks @jm_sysadmin for looking up the hard stuff, @ec.bryantu you can also stick that data into a solarwinds event log monitor and I can confirm it works fine without needing to write any code