We have made minor but important modifications to the Database Configuration settings, which are still posted under March, 2008 archive. The archived posting includes the most current recommendations. We’ve also posted a Microsoft Word version of the checklist below.
- Changes specific to Microsoft Windows Server 2008 environments:
- Max Server Memory for a SQL Server instance does not need to be managed with a custom setting, see KB918483 for details. (Configuration Part 1)
- Partition alignment on SANs does not have to be performed manually on Windows Server 2008. The default partition offset is 1024K which is suitable in most scenarios. (Configuration Part 2)
- We have also modified our recommendations to set Auto Update Statistics Asynchronously to FALSE (from TRUE), which is the default setting. If you modified this setting, please change it back to FALSE. (Configuration Part 2)