The Microsoft Dynamics NAV SQL Evaluation Diagnostic collects information about the Microsoft Dynamics NAV SQL implementation. This diagnostic requires SQL administrative rights and collects the following information:
After it collects this information, the diagnostic performs more than 22 tests and then provides helpful suggestions that are based on these tests.
- Physical server: Information such as CPU count, amount of RAM, and operating system
- Microsoft SQL Server setup: Information such as the version of SQL that is currently running, the name of the server and the process ID, and whether the instance of SQL Server is clustered, in addition to properties such as default index fill factor and minimum and maximum server memory
- SQL database setup: Information such as whether AutoClose or AutoShrink is enabled for the database. The diagnostic also checks whether the statistics are being automatically created or updated. The diagnostic examines the kind of recovery that is enabled for the database and whether the database is compressed, in addition to other properties necessary to help support the installation.
- Microsoft Dynamics NAV database setup: Information that is maintained in some Dynamics NAV tables to determine how the application is set up. Most of the information that is reviewed can be found on the Alter Database form in the Microsoft Dynamics NAV product.
- Database file or files setup: Information about the setup of the database files. This includes properties such as the location of the files, whether the files have auto-growth enabled, and to what filegroup each file belongs.
After it collects this information, the diagnostic performs more than 22 tests and then provides helpful suggestions that are based on these tests.