Optimizing SQL Server performance

There can be several factors that contribute to the slow performance of a system. In this section, we are trying to focus on some of the basic elements.

Data access

In Microsoft Dynamics NAV Version 2009 and earlier, Dynamics NAV was used for Open Database Connectivity (ODBC) as an API to connect to the database. But thereafter, it has implemented the ADO.NET API to interface with the SQL Server. There are many advantages of using ADO.NET over ODBC. We shall discuss them briefly.

ADO.NET and ODBC are both Microsoft Standard Application programming interfaces. ADO.NET is quicker and gives flexibility in its setup in comparison to its counterpart, ODBC. Here are some of the benefits of using ADO.NET over ODBC:

  • Simple ...

Get Mastering Microsoft Dynamics NAV 2016 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.