May 7, 2019 at 11:11 am
Hi there,
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?
May 8, 2019 at 7:47 pm
It appears you can simply alter the endpoint and change the IP address instead of recreating the listener:
With this code -
ALTER ENDPOINT [MyEndpoint]
STATE = STARTED
AS TCP (LISTENER_PORT = 5023, LISTENER_IP = (10.x.x.x))
FOR DATA_MIRRORING (ROLE = ALL, AUTHENTICATION = Windows Negotiate,
ENCRYPTION = REQUIRED ALGORITHM AES)
Here is more information on this -
https://www.ryanjadams.com/2016/01/change-availability-group-endpoint-ip/#axzz4yzaoZP8L
GO
May 9, 2019 at 9:30 am
Thanks for the reply.
I'm still not sure I'm going down this route as all my servers are virtual and not sure adding another NIC would even help.
Regards
Andrew
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply