Looking for some advice here:
I currently have 3 SQL servers in a single AG with a single network card on each server. During times of heavy network usage, we are sometimes seeing failovers to a secondary server. After some research, I see that the way round this is to have a dedicated NIC for the AG traffic on a private IP address range.
What I was wondering is, it is possible to drop and create existing endpoints/listeners with the updated IP addresses or would I have to create a new AG and move databases across to it?