RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

Microsoft Dynamics NAV/SQL Server Configuration Recommendations

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

Categoria: Sql Server ALL
venerdì, 12 set 2014 Ore. 21.53

Messaggi collegati


Statistiche
  • Views Home Page: 344.110
  • Views Posts: 722.009
  • Views Gallerie: 0
  • n° Posts: 345
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003