Database Optimization

Your company has a large database and Navision has shown bad performance lately. The database needs optimization.

The problems with bad performance may be because of insufficient SQL server optimization, keys (both Navision and SQL server) optimization, C/AL code optimization, hardware optimization, network optimization. We will help you with directives which will make the performance much better. We will find most of milestones which can influence productivity of database server.

If the target database is based on SQL Server, our team can offer code optimization by using new C/AL functions aimed specifically at code optimization for SQL Server.

Code optimization service is especially important when upgrade process includes migration from a native database to SQL Server.

Code will be reviewed and rewritten where required to ensure optimal performance when running code on SQL Server:

  • Index optimization
  • Recoding of low performance objects

Need to do some projects in Microsoft Dynamics NAV?