Skip to content
Microsoft Dynamics 365 Blog


Using SQL Server Transparent Data Encryption (TDE) with Dynamics NAV 

Over the last few months, the Dynamics NAV team has been testing compatibility with SQL Server Transparent Data Encryption (TDE), and we are now proud to announce that the following Dynamics NAV versions all support SQL Server Transparent Data Encryption (TDE): Microsoft Dynamics NAV 2018 Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2016 Microsoft Dynamics...Read more

Troubleshooting SQL Queries Generated by Dynamics NAV 

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   Please get back to us if you miss documentation around...Read more

Database deadlock detection and monitoring in Dynamics NAV 2017 

Sometimes a programming error in C/AL can lead to users experiencing errors due to database deadlocks. A database deadlock can occur when two sessions try to update the same data, and are acquiring database locks in different orders. For example, let’s imagine two code units 10001 and 10002, which both do updates to records in...Read more

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0 

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,...Read more

SQL Server 2016 and Dynamics NAV 

SQL Server 2016 released in June this year with many new and interesting capabilities. For further information, please take a look at the product information at this location: Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to...Read more

How to proactively avoid parameter sniffing step-by-step 

In the following blog post the so called „parameter sniffing“ is explained: The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d...Read more