SQL Server Check

Trace flag 9567

This is one of many SQL Server checks performed by our free sp_Check tools.

Learn More About Our sp_check Tools

Checks Performed

ID
Check
419
Trace flag 9567 enabled

What’s the issue?

Trace flag 9567 is enabled globally.

Why is this a problem?

This trace flag enables compression of the data stream for availability groups during automatic seeding. This compression can significantly reduce the transfer time during automatic seeding, but also increases the load on the processor.

What should you do about this?

If you are not currently automatically seeding a replica, or do not plan to do so in the future, you can disable this trace flag.

Read more…

Tune compression for availability group – SQL Server Always On | Microsoft Learn

Type

Availability

Importance

High

sp_Checks