Folder Dynamics NAV
Last updated 11 November 2020.
Dynamics NAV/BC - Performance troubleshooting and profiling for Dynamics NAV | BC and SQL Server
Checks SQL Server in scope for some of most common skewed Best Practices and performance issues.
Valid from SQL Server 2012 onwards. By default all databases in the SQL Server instance are eligible for the several database specific checks, and you may use the optional parameter to narrow these checks to specific databases.
Only a system administrator/local host administrator is able to perform all checks or functions.
This code and information are provided "AS IS" without warranty of any kind, either expressed or implied. Furthermore, the author or Olav Treffurt IT Consulting shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.
Contains the following informational sections:
This query opens the "Objects" table of the Daynmaics NAV/BC database.
This query works up to database version 14 of Microsoft Dynamics 365 Business Central.
This function is no longer used in the current version and will not be visible in future versions of the V8 Search XE.