SQLTeam.com | Weblogs | Forums

Always On synchronous commit


#1

Hi all,

I have a two node AlwaysOn Availability Group setup. It has synchronous commit with automatic failover. I have a few questions.

What will happen if one of the nodes goes down permanently -Does the synchronous commit option automatically get changed to asynchronous? Or does that have to be done manually?

If the synchronous commit option remains after one of the nodes goes down does that mean transactions will remain hung on the primary until the secondary comes back online?

Thanks