Skip to main content
Dynamics 365
  • 1 min read

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


							Avatar of Kennie Nybo Pontoppidan

Kennie Nybo Pontoppidan

See Kennie Nybo Pontoppidan posts

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.