O'Reilly logo

Microsoft Dynamics NAV Administration by Sharan Oberoi, Amit Sachdev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Investigating the performance of the database

There are a few key performance troubleshooting techniques that are effective in identifying the bottlenecks in the performance of the database.

Updating statistics

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

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:

  1. Look for the index defrag tool.fob file in the Dynamics NAV SQL resource toolkit. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required