Monday, September 14, 2009

Links for September 13, 2009

tuning your tempdb

Optimizing tempdb performance
In earlier versions of SQL Server, the PAGE_VERIFY database option is set to NONE for the tempdb database and cannot be modified. In SQL Server 2008, the default value for the tempdb database is CHECKSUM for new installations of SQL Server. When upgrading an installation SQL Server, the default value remains NONE. We recommend that you set the PAGE_VERIFY option for the tempdb database to CHECKSUM.

Why this isn't easier, I don't know, but these instructions are great.

No comments:

Post a Comment

Older Posts