Post reply

AlwaysOn connections

  • May 27, 2016 at 10:24 am

    #400217

    Hi,

    I have implemented AlwaysOn, now before to switch on secondary replicas I would like to be sure all applications have been modified to connect into the AlwaysOn listener.

    Do you know if there is a way to understand if a sql connection was made on primary replica ip or alwayson listener?

    thanks

    Regards

  • May 31, 2016 at 1:57 pm

    #1882270

    vincenzo_capelli (5/27/2016)

    Hi,

    I have implemented AlwaysOn, now before to switch on secondary replicas I would like to be sure all applications have been modified to connect into the AlwaysOn listener.

    Do you know if there is a way to understand if a sql connection was made on primary replica ip or alwayson listener?

    thanks

    Regards

    Have you configured your readonly routing configuration for your AG?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply