There are a few key performance troubleshooting techniques that are effective in identifying the bottlenecks in the performance of the database.
There are several tools available from various Microsoft Dynamics ISV(s) that provide effective tools for monitoring the performance of a Dynamics NAV database. We will limit ourselves to the SQL Resource Kit provided by Microsoft in this section of the chapter.
The Index Defrag tool is a Dynamics NAV tool that comes along with the Microsoft Dynamics NAV SQL Resource Kit, and helps in identification of the keys that need to be defragmented:
index defrag tool.fobfile in the Dynamics NAV SQL resource toolkit. ...