Microsoft Dynamics NAV/SQL Server Configuration Recommendations

...old but VERY GOOD & ACTUAL post about NAV/SQL Configuration by NAV Team

Michael De Voe, a Senior Premier Field Engineer at Microsoft, has compiled a set of recommendations for SQL Server configuration to improve performance when running Microsoft Dynamics NAV 5.0 and later versions with one of the following versions of SQL Server:

• Microsoft SQL Server 2005 SP3 x64
• Microsoft SQL Server 2008 SP1 x64
• Microsoft SQL Server 2008 R2 x64

 The attached document contains Michael's recommendations, including the following options and parameters:

• 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

 These postings are provided "AS IS" with no warranties and confers no rights. You assume all risk for your use.

original post & PDF here:

http://blogs.msdn.com/b/nav/archive/2010/09/28/microsoft-dynamics-nav-sql-server-configuration-recommendations.aspx?wa=wsignin1.0

NAV - SQL Config.pdf