Optimizing SQL Server Performance with Microsoft Dynamics NAV
The following articles describe how to optimize performance in Microsoft Dynamics NAV 2018 when accessing data from the SQL Server database.
Setting SQL Compatibility Level to Optimize Database Performance
C/AL Database Functions and Performance on SQL Server
Configuring Query Hints for Optimizing SQL Server Performance
Troubleshooting: Analyzing Long Running SQL Queries Involving FlowFields by Disabling SmartSQL
Troubleshooting: Using Query Store to Monitor Query Performance in Dynamics NAV
Troubleshooting: Using the Event Log to Monitor Long Running SQL Queries in Dynamics NAV
See Also
Configuring Microsoft SQL Server
Microsoft SQL Server documentation