1

Does activating the TF9567 seeding mode trace flag speed up the synchronization process in AlwaysOn?

I am using SQL Server 2019.

Improve this question
1
  • What do you exactly mean when you say ""speeds up sync process", so are you talking about seeding speed, if so, then yes it does.
    – Shanky
    Commented Nov 9, 2020 at 8:33

2 Answers 2

Reset to default
2

Trace Flag 9567 : Enables compression of the data stream for Always On Availability Groups during automatic seeding. Compression can significantly reduce the transfer time during automatic seeding and will increase the load on the processor. For more information, see Automatically initialize Always On availability group and Tune compression for availability group.

As the document says, just when automatic seeding process during. Synchronization doesn't relate to this trace flag.

Improve this answer
0

Setting the trace flag I have seen with 200GB db sync time was about 40 minutes vs 8+ hours without the trace flag! That was going to a DR box in a different data center.

Improve this answer

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.