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