December 11, 2009 at 9:35 pm
what is the good,bad and ugly part of 806 trace flag?Will the database performance be slow if i enable in my production
December 12, 2009 at 2:01 am
Why are you considering enabling traceflag 806? On whose advice with what reason? What do you think it does?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2009 at 5:01 am
there is database corruption. the IO system is robust
December 12, 2009 at 7:55 am
You don't want to turn it on unless you're *not* covered by page checksums already. It's going to vastly slow down reads while it does the extra auditing.
No problem if you want to turn it on, I've discussed this trace flag publicly in sessions at TechEd in 2007, just don't leave it on permanently.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply