2

Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally, but somehow force synchronous replication for one table between nodes?

Nodes are in different subnets/continents.

Thank you in advance.

3

Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally

Yes, with AlwaysOn Availability Groups having commit mode set to asynchronous commit for a replica. That'll be by-database, so you'll have to group the databases into the AG that you want to see that happen with.

but somehow force synchronous replication for one table between nodes

It really depends on your definition of "synchronous", but in the truest of definitions then no, you can't have synchronous commit for individual tables. It'd have to be by database/availability group.

  • +1 You could put that table only in a different database and hence a different AG. – Aaron Bertrand Dec 17 '13 at 16:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.