locked
Monitoring Availability Group Failover RRS feed

  • Question

  • Hello,

    Is is possible to monitor a failover of a SQL availability group with SCOM 2016? Meaning when AG transfers to a different node, SCOM should alert that a failover occured.

    The availability groups in our environment are currently monitored by SCOM, but I couldn't find a monitor in the Health Explorer that satisfies the above requirement.

    Thank you.

    Wednesday, February 12, 2020 1:23 PM

Answers

All replies

  • Hi,

    You can find what SCOM monitors in the SQL Server management pack guide:

    https://www.microsoft.com/en-us/download/details.aspx?id=56203

    I don’t think it monitors when a failover occurs, you will have to create an own monitor/rule for that and check for the event created whenever a failover occurs.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by Fazio_Tech Wednesday, February 12, 2020 1:58 PM
    Wednesday, February 12, 2020 1:37 PM
  • Hi,
     
    Research and find the following article for the reference:

    https://solutioncenter.apexsql.com/how-to-monitor-sql-server-failover-events-automatically/


    Hope it can help.
     
    Best regards.
    Crystal

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, February 13, 2020 2:31 AM
  • Hi Fazio,

    Failover of a SQL AG can generate an alert if its cluster specific. The alert rule is- 'Cluster resource failed' and source is 'Cluster service'. There is also an alert monitor- 'WSFC Cluster(rollup)' or 'Cluster resource group offline or partially online' but that will only alert when the AG is unavailable,not sure if it will alert on a failover.

    You could definitely setup a custom rule/monitor if the above doesn't meet your expectations!

    Please remember to mark the replies as answers if they help.

    Thursday, February 13, 2020 8:07 AM