SQLIOStress simulates a very heavy SQL Server workload and should do a far better job of discovering flaws in your hardware setup than individual hardware vendors' diagnostics will.
Trace flag 806 will cause 'DBCC-style' page auditing to be performed whenever a database page is read into the buffer pool.
Trace flag 3422 will cause auditing of transaction log records as they're read win
Thanks to Paul S. Randal from SQLSkills for these tips. Details at
http://www.sqlskills.com/blogs/paul/post/How-to-tell-if-the-IO-subsystem-is-causing-corruptions.aspx
No comments:
Post a Comment