Performance and installation tips
For a successful NAV implementation, performance is an important aspect to consider and to carefully monitor.
The following are the main NAV points to check in order to have better performance:
- Data tier (SQL Server Database)
- Service tier
- C/AL code
Data tier (SQL Server Database)
Microsoft Dynamics NAV relies on Microsoft SQL Server as its database, so recommendations on optimizing SQL Server performance for NAV are much the same as other types of data-intensive applications:
- Split the database into more data files and locate them on different disks.
- Every time a record is added, modified, or deleted from any table in the database, SQL Server updates all the indexes that are related to those tables. Check the indexes ...