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 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…


Moving a Dynamics NAV database with file groups to Azure

The short story: If you use SQL Server for your Dynamics NAV database, and if you are using multiple file groups (other than PRIMARY), as per SQL Server recommendations for better IO performance, and if you need to export the database to Azure, then you need to use the latest update (August 2016 update or…

0

How to export a Dynamics NAV database on SQL Server 2016

If you use SQL Server 2016 for your Dynamics NAV database, and you need to export a database to the .bacpac format, then please make sure that you are running the latest update (August 2016 update or later) of the Microsoft SQL Server Data-Tier Application Framework (DacFx) or SQL Server Management Studio (SSMS). If you…


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…

10

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: https://www.microsoft.com/en-us/cloud-platform/sql-server 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…

15

How Do I Set Up Microsoft Dynamics NAV to work with Azure SQL Database

Dynamics NAV 2016 supports the option of using Azure SQL Database, and we have recorded a “How Do I” video to explain the steps involved in deploying a Dynamics NAV SQL Server database to an instance of Azure SQL Database. This blog post includes a Windows PowerShell script that can be used to configure the Dynamics…

4

SQL Server Worker Threads and Microsoft Dynamics NAV

Microsoft Dynamics NAV has been configured to use the Microsoft SQL Server database engine as efficiently as possible. This includes using SQL queries which are appropriate for parallel query execution to speed up the retrieval of data when the SQL Server is configured to allow this. Parallelism in SQL Server can be controlled using the…

9

Watch Out for Zombies When Using Microsoft Dynamics NAV with “xact abort” Enabled

If you have turned on the xact abort connection setting option for the Microsoft Dynamics NAV SQL Server instance, then you should watch out for Zombies. With this option turned on, users of your solution risk seeing an error stating This SqlTransaction has completed; it is no longer usable along with a crash signature which includes a…

2

Compatibility with SQL Server 2014

SQL Server 2014 released earlier this year with many new and interesting capabilities. For further information, please take a look at the product information at this location: http://www.microsoft.com/en-us/server-cloud/products/sql-server/default.aspx. Over the last few months, the Microsoft Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to…

27

Synchronize metadata, please…

One of new procedures/functions we have in NAV 2013 R2 is “metadata synchronization”. It is process when object (table) description done in C\SIDE by NAV developer is applied to SQL object (object structure in SQL becomes the same as we have in NAV object designer).It is described at http://blogs.msdn.com/b/nav/archive/2014/03/27/table-synchronization-paradigm-in-microsoft-dynamics-nav-2013-r2.aspx Unfortunately synchronization step is not mentioned in…

6