http://blogs.msdn.com/b/saponsqlserver/archive/2011/12/22/faster-dbcc-checkdb-released-in-sql-2008-r2-sp1-traceflag-2562-amp-2549.aspx&#160; CHECKDB Times are Reduced with New CHECKDB Functionality Customers with larger databases are recommended to upgrade to SQL 2008 R2 SP1 Cumulative Update 4 to benefit from new improved CHECKDB functionality described in KB2634571 .&#160;&#160;&#160;en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/saponsqlserver/archive/2011/12/22/faster-dbcc-checkdb-released-in-sql-2008-r2-sp1-traceflag-2562-amp-2549.aspx#10294045Mon, 16 Apr 2012 10:19:49 GMT91d46819-8472-40ad-a661-2c78acb4018c:10294045Cameron - MSFT SAP Program Manager<p>Yes, sure - just enable the trace flag either at startup or globally and run.</p> <p>Ensure Tempdb is sized appropriately</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10294045" width="1" height="1">http://blogs.msdn.com/b/saponsqlserver/archive/2011/12/22/faster-dbcc-checkdb-released-in-sql-2008-r2-sp1-traceflag-2562-amp-2549.aspx#10278581Tue, 06 Mar 2012 18:49:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:10278581Bill<p>I want to test out this on SQL Server 2012, can i just enable flag 2562 and 2549? Please advise. thx Bill</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10278581" width="1" height="1">