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
Store

SQL Always-On AG Status - Alert if Primary Node Changes

We are currently monitoring via a listener for our SAO cluster. We have 3 servers in the AG Group (Primary, Secondary, DR). Is there a way to send out an alert in DPA if the Primary (Active) node changes in the availability group?

Find more posts tagged with

Accepted answers

mandevil

Check out this document - let me know if that's what you were looking for: Change_physical_node_name.docx

All comments

mandevil

Check out this document - let me know if that's what you were looking for: Change_physical_node_name.docx

kyle.robertson

Thanks, I believe this is what I am looking for, however, I am getting the following error below after using the scripts provided in the document.

BROKEN

LISTNAME

Cannot insert the value NULL into column 'NAME', table 'dpa_repository.dbo.COND'; column does not allow nulls. UPDATE fails.

kyle.robertson

I see the issue. The alert name is hardcoded in the t-sql statement. I have updated it to the name I provided and it works. Please ignore. Thank you for the help .