Press "Enter" to skip to content

Trace Flags 2549 and 2562

Lonny Niederstadt has a public service announcement:

Trace flag 2549 is no longer required for checkdb or checktable in SQL Server 2016++.

Trace flag 2562 may still benefit checkdb on a system (depends on disk characteristics and tempdb) in SQL Server 2016++, but is not expected to benefit checktable due to the already-limited scope of checktable activity.

Click through for the full story.