Troubleshooting SQL Queries Generated by Dynamics NAV

The documentation on Optimizing SQL Server Performance with Microsoft Dynamics NAV has been updated with information about:

  • Troubleshooting long running SQL queries involving FlowFields by disabling SmartSQL.
  • Using SQL Server 2016 Query Store to monitor query performance in Dynamics NAV.

 

Read more at
https://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-performance-with-microsoft-dynamics-nav

 

Please get back to us if you miss documentation around running Dynamics NAV on SQL Server (just comment below).