Chapter 6. Performance Tuning

A significant number of companies are now considering and using the SQL Server option for Dynamics NAV. As their databases expand, the NAV experts are experiencing a surge in the number of requests for fine-tuning the database performance of Microsoft Dynamics NAV. While it's easy to get into the programming and technical part, we've tried to focus more on the administration part and how a few things can make a huge impact on the performance of the database. This includes some of the following activities and how to do them properly while using the Microsoft Dynamics NAV with SQL Server option:

• Configuring and setting up a Microsoft SQL Server database for Microsoft Dynamics NAV

• Writing customized applications and code efficiently for the Microsoft Dynamics NAV for Microsoft SQL Server database option

• Periodically tuning and monitoring the performance of the SQL Server database

To cover these options in this chapter, we highlight some of the most commonly used methods...