Best practices for installing and configuring Microsoft SQL Server for Microsoft Dynamics NAV


The documentation on Installation Considerations for Microsoft SQL Server and Microsoft Dynamics NAV has been updated with information on recommended settings for SQL Server 2012, 2014, and 2016.

The documentation contains recommendations on topics such as

  • Storage and recommended disk block size
  • Virus scanning
  • Memory
  • TempDB database configuration
  • Auto-growth of database and/or transaction log files
  • Max degree of parallelism (MAXDOP)
  • Trace flags 1117 and 1118 (full extents only and equal growth of all files in a filegroup)
  • Service accounts and instant file initialization (Perform Volume Maintenance Tasks)
  • Statistics (auto-create, auto-update and maintenance jobs)
  • Page Verify
  • Backup and restore

Read more at
https://msdn.microsoft.com/en-us/dynamics-nav/installation-considerations-for-microsoft-sql-server

Comments (2)

  1. This blog article announces information about SQL for NAV in general, but the linked article is applicable to NAV 2017 only. Correct? It would be helpful to update this blog article with a NAV 2017 reference then.

    1. Dear Natalie Karolak,

      The page on MSDN is applicable to all supported (as of 2017-03-01) versions of NAV:
      Microsoft Dynamics NAV 2017,
      Microsoft Dynamics NAV 2016,
      Microsoft Dynamics NAV 2015,
      Microsoft Dynamics NAV 2013 R2, and
      Microsoft Dynamics NAV 2013
      on all supported (as of 2017-03-01) versions of SQL Server
      SQL Server 2016,
      SQL Server 2014, and
      SQL Server 2012

Skip to main content