SQL Server Configuration Recommendations

There is very interesting Blog post on Microsoft Dynamics NAV Team Blog about recommendations for SQL Server Setup.

Michael De Voe has written one document which consists of pointers for setting up SQL 2005 or SQL 2008 for Dynamics NAV.

Here's short list of recomendations:

• Max Server Memory,
• Auto-Create Statistics,
• Auto-Update Statistics,
• Auto-Grow,
• Database Compatibility Level,
• Trace Flag 4136,
• Trace Flag 4119,
• Data files for TempDB,
• Disk Alignment,
• Read Committed Snapshot Isolation (RCSI),
• Max Degree of Parallelism,
• Dynamics NAV Default Isolation Level,
• Dynamics NAV "Lock Timeout",
• Dynamics NAV "Always Rowlock",
• Maintenance Jobs,
• Instant File Initialization,
• Optimize for Ad Hoc Workloads,
• Page Verify,
• Lock Pages in Memory.

Here are links to:
Dynamics NAV Team Blog
Michael's SQL recomendations