• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 32 subscribers
  • Views 238 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

SQL Server Agent - HA Configuration

jameslindsay

I have an alert configured using a Windows Service Monitor. I have two servers in an active/passive cluster where the Agent only runs on the active server. However, the alert is triggering on the server that is passive. What can I do I alert on the active server only in this configuration?

  • 0

    What I would do, is add a new node custom property, call it something like "PassiveNode", and set it as a yes/no type.

    Via 'Manage Custom Properties' in settings, set this property to false for all nodes, and then go back and set it to true for your passive cluster member.

    Finally, edit your alert and add in to the trigger condition logic "where Node Custom Property 'PassiveNode' = false (or 0, depending on how you want to roll)".

    That should exclude the passive nodes from your alert!

    Of course, you'll need to ensure you swap the CPs over if you swap the passive/active roles around to avoid false positives going forward.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.