Post reply

SQL Server Always On Asynchronous Mode of Communication

  • March 26, 2019 at 9:50 pm

    #2031608

    Hi  Guys,

    We  are having a SQL Server instance  SQLINST1 (Primary) in  one DataCenter (DC1)   and SQLINST2 (Secondary) in another DataCentre (DC2) . We had configured Always on (AG1)  Asynchronous mode of communication.  

    We had configured the  SQLINST1  as " Synchronous mode" with Manual fail-over and SQLINST2 as " ASynchronous mode" with Manual fail-over. Is this is the right configuration or we need make SQLINST1  as " ASynchronous mode".Is there anything wrong in the design with Primary SQL Instance configured with Synchronous mode?

    Please guide me.

  • March 26, 2019 at 11:35 pm

    #2031853

    The issue with setting SQLINST1 to synchronous is that after a failover, it will be a synchronous secondary whereas your normal state is that the secondary is asynchronous. Ideally, if you only have two replicas and your latencies between them means you need to use asynchronous commit, then you shoudl set this on both replicas. It only affects them when they are the secondary, but it helps ensure consistent behaviour and performance post-failover.

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

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