locked
SQL 2014 High Availability (Always On) RRS feed

  • Question

  • Greetings

    I have two SQL 2014 Servers configured with a handful of Availability Groups. Everything on this front is working well. My question is in relation to the replication and the underlying network. The Servers currently have one network card each. I would like to separate the client connectivity from the replication network.

    I can obviously add an additional NIC to the machine and configure for replication network but how do I tell SQL Server to use this link over the other? Does anyone have any pointers please on how to do this?

    Many thanks

    Keeka

    Monday, July 27, 2015 8:10 AM

Answers

  • Hello Keeka - Server 2012/ 2014 AlwaysOn Availability Groups uses database mirroring endpoint for communication between Primary replica & one or more secondary replicas. This SQL Server instance endpoint is then shared by one or more availability group replicas and/or database mirroring sessions and is the way by which communication between the primary replica and the associated secondary replicas takes place

    Having said this, this whole communication takes place over Listener Port & Listener IP and that you can change while defining the Endpoint, such as this:

    CREATE ENDPOINT [Test_Hadr_endpoint] 
        AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (10.10.10.10))
        FOR DATA_MIRRORING (ROLE = ALL);
    
    

    More information & test results here:

    http://sqlperformance.com/2012/10/system-configuration/dedicated-network-availability-group

    Hope this helps !


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    • Marked as answer by Charlie Liao Wednesday, August 5, 2015 1:58 AM
    Monday, July 27, 2015 8:18 AM

All replies

  • Hello Keeka - Server 2012/ 2014 AlwaysOn Availability Groups uses database mirroring endpoint for communication between Primary replica & one or more secondary replicas. This SQL Server instance endpoint is then shared by one or more availability group replicas and/or database mirroring sessions and is the way by which communication between the primary replica and the associated secondary replicas takes place

    Having said this, this whole communication takes place over Listener Port & Listener IP and that you can change while defining the Endpoint, such as this:

    CREATE ENDPOINT [Test_Hadr_endpoint] 
        AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (10.10.10.10))
        FOR DATA_MIRRORING (ROLE = ALL);
    
    

    More information & test results here:

    http://sqlperformance.com/2012/10/system-configuration/dedicated-network-availability-group

    Hope this helps !


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    • Marked as answer by Charlie Liao Wednesday, August 5, 2015 1:58 AM
    Monday, July 27, 2015 8:18 AM
  • You would use a set of IPs with their own subnet and then isolate these on their own segment on the vlan or switch.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Monday, July 27, 2015 4:42 PM
    Answerer