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

Data Access

Table Keys and Performance

Bulk Inserts

C/AL Database Functions and Performance on SQL Server

Query Objects and Performance

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