Skip to main content What is Dynamics 365? Guided tours Customer stories Try our products CRM ERP Sales Service Sales Customer Insights Customer Service Contact Center Field Service Supply Chain Management Commerce Finance Project Operations Human Resources Business Central Pricing Business application topics Training & certifications Migrate to the cloud Documentation Events Dynamics 365 Blog Product updates Onboarding and implementation Community Find a partner Software Development Companies Partner resources Microsoft Marketplace Product documentation Technical support On-premises product support Contact us Try for free Sign in

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).

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.