Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace flags 2562 and 2549 behavior. Trace flags 2562 and 2549 are documented in knowledgebase article: https://support.microsoft.com/en-us/kb/2634571and the blog post https://blogs.msdn.microsoft.com/bobsql/2016/06/03/sql-2016-it-just-runs-faster-dbcc-scales-7x-bette...highlights the SQL 2016 DBCC performance improvements.
Trace flag 2549 is used to change how DBCC sees the volume layout of the database. The SQL Server 2016 design change uses the CheckScanner instead of the MultiObjectScanner improving I/O behavior. The design change significantly limits the scope and need for trace flag 2549.
Trace flag 2562 is used to change the batch sizing used by DBCC. This is behavior is unchanged in SQL Server 2016. Use this trace flag with caution as it may require additional TEMPDB space.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.