Summary

We configured a SQL Server database for Microsoft Dynamics NAV by defining database and transaction log files, configuring RAID 10, and defining rules using collations. We also saw how we can write less expensive C/AL code with the help of the following:

• Using FINDFIRST, FINDLAST, FINDSET, NEXT, and ISEmpty statements

• Locking the recordset

• Disabling the "find-as-you-type" feature

We also looked into fine-tuning the performance of the database for Dynamics NAV by using Sum Index Flow Technology, and by accessing and modifying the properties of the indexes. Finally, we looked at identifying and troubleshooting performance issues by updating the statistics and using the tools available in the SQL Resource Kit.