Hi,
I just tested this in our eval environment.
If you change the compatibility level on the primary, it is replicated to the other nodes of the AOAG.
Kind regards,
Andreas
PS: but feel free to test this in your own environment.
Hi Andreas,
yes, i can confirm it. We got an answer from Microsoft. We changed it this morning at the primaryReplica and it was replicated to all other Nodes.
Even our performance issues are gone with changing the Level to 110.