Configuring a SQL Server database for Microsoft Dynamics NAV

It is imperative that while configuring Microsoft Dynamics NAV, the hardware and software recommendations from Microsoft are taken into consideration. From using the latest version of Microsoft Windows, Microsoft SQL Server, or other Microsoft stack products that are intended to be used with Dynamics NAV or the hardware/server sizing, it is important that the Microsoft guidelines for these are taken into account. Some of these software/hardware sizing requirements are mentioned in Chapter 1,

Let's discuss some of the parameters and features that are to be properly set at the time of setting up the Dynamics NAV database on the SQL Server.

Defining database and transaction log files

While defining the Database Files and Transaction Log Files of the Dynamics NAV SQL server database, it is strongly recommended to store the two sets on two separate physical drives. This not only helps greatly in improved performance of the database...