In our always on set up we have One Primary and One Secondary as Synchronous Commit and the DR as asynchronous commit. If i want to change the DR to Synchronous Commit will there be any performance issues ?
If i want to change the DR to Synchronous Commit will there be any performance issues ?
Well, it will take longer to commit transactions, as the primary will wait for the log records to be saved on both sync replicas during each commit. Whether that causes a "performance issue" depends on the transaction throughput, network bandwidth, distance to the DR location, and the tolerance of the application and users for slower commits.