• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Business Central
  • Dynamics NAV
    • NAV 2018
    • NAV 2017
    • NAV 2016
    • NAV 2013
  • Others
    • About
    • Privacy Policy
    • Disclaimer
    • Contact Us

Navision Planet

This Blog is intended to help Microsoft Dynamics NAV / Business Central ERP developers as well as users. If you just go through these blogs you will understand what I have told is correct. The Blog will continuously get update with latest news. This Blog is handled by a group of Microsoft Certified Partners as well as Business Solution Specialists in Microsoft Dynamics NAV and Dynamics 365 Business Central. Feel free to mail us for any doubts.

  • LS Retail
  • Help Topics
    • Finance Module
    • Manufacturing Module
    • Warehouse Module
    • Administration
  • Navision Developer
  • GST
  • D365 Business Central
  • CU Update
    • Download Business Central

Navision Slow on SQL Server

Dynamics NAV(Navision) Slow on SQL Server
Many users experienced Navision getting slower and slower as time goes by. There are many factors that can affects performance of Navision on SQL Server. It can be hardware bottleneck, database design problem or even coding design problem. Below are the few areas that you can look into if your Navision on SQL Server is getting slower.

Run Optimize function

This is the easiest thing you can do. The Optimize function will drop and rebuilt indexes for your tables. SQL Server performance can very much affected by the Index. If you experienced slow in Navision but never do optimization, do it as soon as possible. Don’t wait. The Optimize function can be accessed from

File –> Database –> Information.

Select the table that need to be optimized and click on the Optimize button.

The Optimize function will rebuilt the keys in the selected table and all the related SIFT Tables. Besides rebuilding indexes, the Optimize function will also remove all records with zero values in all the sum fields in SIFT tables. This can free up space and improve speed in updating SIFT records.
I have seen people complaining Navision is very slow but when I asked them, have you ever run the Optimize function from Navision or do any SQL Server Reindex. Surprisingly, they said we never run the Optimize function and we never do SQL Server Reindex since day one we implement Navision. I asked them to schedule a downtime and run the optimize. After run the Optimize function, they find the performance improve significantly.

Interesting Forum discussions on Navision slow on SQL Server:

Mibuso – slow navision on SQL

Navision-SQL Server Performance Specialist
If you really cannot solve your Navision SQL Option slow problem after all efforts, maybe you can consult these specialist.

We will help you on this. Kindly drop one mail or raise one comment on this post. We will connect ASAP and resolve your issue.

Reader Interactions

Comments

  1. Mustafa Tanwar says

    April 17, 2021 at 4:18 pm

    Hi
    I m working on D365BC 14.0, LS Central 14.01. The lookup in LS Cenrtal is extremely slow. On debugging I found that in CodeUnit EPOS datagrid functions , there is vairiable posctrl that reads the data grid using LSRetail NAV POS functions donet variable is responsible.

    Posctrl.initgriddata(pdatagridid, configdataset);

    It is taking lot of time to respond while I have NAV 2015 in some locations and it is taking only 1 or 2 seconds to respond compared to 15 seconds in D365BC 14 LSCentral 14.01
    Please help

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Subscribe

  • Email
  • Facebook
  • Twitter

Our Topics

Administration Analysis Reports Business Central Developer Toolkit Docker Dynamics NAV Beta Download Dynamics NAV Release Error Message Finance Module GST Human Resource Login Error LS Retail LS Retail 2013 Manufacturing Module Microsoft Certified Trainers (MCTs) Microsoft Dynamics Business Central Microsoft Dynamics NAV 2009 Microsoft Dynamics NAV 2013 Microsoft Dynamics NAV 2015 Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2018 MSDyn365BC NAV 2016 Navision Certification Navision Developer Navision Introduction Navision Modules Navision Retail Navision Tips And Tricks Powershell Purchase Order Sales Module SQL Server Useful Sites Visual Studio Code Warehouse Module

Footer

Recent Post

  • Business Central Complete Version List and Direct Download
  • The Upgrade Path to Business Central from any Version
  • Business Central / NAV System Requirements

Search

Contact : support@navisionplanet.com for Microsoft Dynamics NAV (Navision ) and LS Retail Development or Functional support for any modules

 

Editors News Letter


New Microsoft Dynamics NAV Technical Blog opened the Navision Planet Team

MIBUTECH

https://www.mibutech.blogspot.com

Copyright © 2023 Navision Planet