How to handle listener failure in AG? Availability group has concept of listener that directs the requests to appropriate replica.
So is listener a single point of failure? How to handle this?
On Windows, the listener is a WSFC cluster resource with a dependency on the availability group. It is hosted by the current primary AG node and will move to other nodes of the cluster when the primary role switches, providing high availability.