Optimizing SQL Server Performance with Business Central

The following articles describe how to optimize performance in Dynamics 365 Business Central when accessing data from the SQL Server database.

Setting SQL Compatibility Level to Optimize Database Performance

Data Access

Table Keys and Performance

Bulk Inserts

AL Database Methods and Performance on SQL Server

Query Objects and Performance

Configuring Query Hints for Optimizing SQL Server Performance with Business Central

Troubleshooting: Analyzing Long Running SQL Queries Involving FlowFields by Disabling SmartSQL

Troubleshooting: Using Query Store to Monitor Query Performance in Business Central

Troubleshooting: Using the Event Log to Monitor Long Running SQL Queries in Business Central

See Also

Installation Considerations for Microsoft SQL Server
Microsoft SQL Server documentation