none
AlwayOn Monitoring via Alerts - Getting Lots of Emails RRS feed

  • Question

  • Hello,

    I have recently setup AlwaysOn in SQL Server 2017 and has been in Production for several weeks now.  Everything is working fine.  I'm currently in the process of setting up SQL Alerts to monitor AlwaysOn AG.  One of the alerts I created yesterday was to monitor Availability Group role change.  I manually failed over from the primary to secondary to test the alert.  The alert worked however I was getting about 28 email notifications with 1-2 seconds.  All the emails were identical.  My initial reaction was maybe an email for each database in the Availability Group.  But we only have about 15 databases.  So does anyone know why I was getting 28 alerts when I failed over from primary to secondary?  Is this how it supposed to work or did I misconfigured some thing?  Attached is a partial listing of those emails.

    Thank you

    • Edited by Sidney L Tuesday, February 12, 2019 3:48 PM
    Tuesday, February 12, 2019 2:34 PM

All replies

  • Moderators, 

    This question has been posted in the HADR forum here, can you please merge both of the threads? Thanks!


    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Tuesday, February 12, 2019 4:19 PM
  • Moshin,

    Sorry about that.  Let me find out how to merge these.  I have not done this before.

    Thanks

    Tuesday, February 12, 2019 4:50 PM
  • Moshin,

    Sorry about that.  Let me find out how to merge these.  I have not done this before.

    Thanks

    No worries. Hopefully someone will help fix it. 

    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Tuesday, February 12, 2019 5:05 PM