March 29, 2024 at 5:08 pm
Hello,
We are trying to optimize the no. of alerts generating while Availability Group fails over.
Event ID: 1480: Database Replica Role Changed
Event ID: 19406: Availability Group Replica Role changed.
As per my understanding Event 1480 can never happen without 19406.
Hence it is ok to disable alert for 1480.
Please let me know it will fail to detect any issues if we do so.
March 30, 2024 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 10, 2024 at 7:05 pm
EDIT: Actually, this thread seems to arrive at your conclusion (Error 19406 being all you need) but I suggest reading through those other articles too anyway. HTH
https://www.sqlservercentral.com/forums/topic/alwayson-availability-failover-
Hi,
You can check the link below and the other links in that series including the comment to the article, pasted below. There may be reasons why you don't want to disable the 1480.
https://tracyboggiano.com/archive/2017/05/monitoring-ags-part-2-sql-agent-alerts/
Robert says:
July 15, 2017 at 18:15
Another good message id to monitor in an availability group is id 19406, which is for replica state change. This event will occur for all the events listed in this article and more. 19406 kind of generic due to a lot of different possible events triggering this error. It requires further investigation to determine the cause.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply