I just finished my sessions last week at TechEd India 2010 but during the session as I spoke about Recovery and Consistency of data with SQL Server and the enhancements of SQL Server 2005 adding CHECKSUM to the database, I found not many to know its importance. There has been an enhancement to SQL Server 2008 specifically around this which I thought is worth a mention over the blog.
The database option page_verify_option can be set to CHECKSUM in tempdb database starting with SQL Server 2008. This is a great enhancement that can be leveraged while troubleshooting unexplained behavior that involves tempdb.
For new installations, the page_verify_option is set to CHECKSUM by default for tempdb as well as other system databases. For upgraded installations, the page_verify_option is set to NONE by default. There is a PBM policy that checks this and I recommend you to turn this on.
This entry was posted on Thursday, April 22nd, 2010 at 04:22 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.