1

I am seeding a database using distributed availability group. Seeding is automatic but synchronization mode is asynchronous. Log stream compression for automatic seeding is NOT enabled via TF 9567. Value for 'is_compression_enabled' in DMV 'sys.dm_hadr_physical_seeding_stats' is showing 0 during seeding operation.

As per MS documentation 'Log stream compression is enabled by default for asynchronous replicas.' According to this, shouldn't log stream compression be enabled by default for this seeding operation? That's why I got this question if this is same behavior for Distributed availability groups also.

1 Answer 1

1

As per MS documentation 'Log stream compression is enabled by default for asynchronous replicas.'

This is when the Async replicas are functioning as part of AG post AG configuration, if you see the document it says enabled for Asynchronous- commit replicas. During automatic seeding no matter sync or async replica the log compression is disabled by default. To enable it as you know you have to enable the trace flag 9567.

Hope this is clear

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.