0

How does SQL Server handle IO in terms of availability group secondaries? To give an example scenario: A 2 node cluster with 2 Availability groups Each AG is primary on a different node. Therefore each node is a primary for one AG but a secondary for the other. Will IO for the primary workload be prioritised over the replicated data, assuming all disks are shared? Also would this differ if the secondary was in sync or async mode?

1 Answer 1

0

Will IO for the primary workload be prioritised over the replicated data, assuming all disks are shared?

No, I have not heard any such thing that SQL Server will prioritize certain IO over other. You have an option to set High Priority for SQL Server by using sp_configure but it is not recommended and mostly counter productive.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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