Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Scott Mowry]

We are in the middle of a step to get us to BC21, but we had to go to BC14 dues to heavy customization to Nav2009 that had to be brought forward no matter what.  We are having horrible performance issues in BC14.  We have constant lag and screen freezes constantly.  I have maxed out all the hardware for performance issues that I have read about, but need to find an actual solution.  I don’t know if it is the custom code that is causing the issues or something else.  Any advice is welocmed.

——————————
Scott Mowry
Bishop Lifting Products
Houston TX
——————————

[Gregory Alford]

How many extensions do you have? We had many extensions, but over time we merged them all into one extension and we now have great performance. You could also try installing SQL Mantra to see where you might be able to improve the performance of SQL Server.

——————————
Gregory Alford
Director of Technical Resources
Tri Star Metals LLC
Aurora IL
——————————
——————————————-

[Chris Young]

There are a number of things that can hinder performance of a BC Database.  Certainly, poor programming or long running queries can hinder performance, but some things to check for:  
1. Change Log – too many tables being tracked in the change log, especially Sales Orders / Line or any posted tables create nuisance entries and cause problems
2. Automatic Cost Posting / Adjustment – While I am a fan of having this on, if you have performance issues and have huge posting volumes – you can do this as a daily function / job queue to eliminate delays during normal processing.
3. Analysis Views and Automatic Updates – These can cause problems with performance and should be updated prior to running financial reports.

Could be a plethora of other things, but these are some quick checks that might provide some benefit.

Good luck!

——————————
Chris Young
Chief Financial Officer
Clients First Business Solutions
Holmdel NJ
——————————
——————————————-

[Spencer Coulter]

I’m assuming you are on BC14 on prem based on the description, the latest releases of BC have a performance profiler that is awesome for these scenarios to see what is causing slowdowns but that’s several releases from 14. Being on prem one of the first things I would do is run some SQL traces and just review where you are seeing the database hit heaviest. My guess would be logic is out there re-querying a table over and over in SQL vs storing in memory for a long running process. It won’t say this is exactly the code but should help you quickly narrow down some focus areas that are hitting heaviest.

Also note that you should be considering a re-write of the logic either way, the model is full extension now and never going back so you moved forward a bit but will be trapped there forever if you don’t start moving into extensions near term (ie. before you need to)!

——————————
Spencer Coulter
Director, Business Applications

RSM US LLP
D: 515.281.9248 F: 515.471.5261
E: Spencer.Coulter@rsmus.com
——————————
——————————————-

[Kevin Brennan]

 

We recently migrated to a new file server (BC 14 On Prem – targeting cloud migration Aug 2023.)

 

Our performance benchmark report, “Inventory Valuation”, took 45 min on the old server, and 90 min on the newer, much faster SQL Server.

 

We had a SQL Specialist examine/trace everything.  He recommended some indexes be added.   Now, I think it’s down to 30 on the new server (down from 45 on the old server.)

 

(Sales line table?  Something like that.)

 

Hope this helps!

 

Regards,

 

-Kevin

 

 

 

Kevin Brennan Director of IT at Mayco Colors   Mobile: 614-204-5222 Email: Kevin.Brennan@MaycoColors.com   4077 Weaver Ct S Hilliard, OH 43026   http://www.maycocolors.com

 

 

——————————————-

[Joseph Flynn]

Check to see if you have CRM integration turned on. All master table changes were writing to these tables. We are on the original 2018, I believe it’s version 11 or 12.
Index tuning helps as well.

——————————
Joseph Flynn
Sr. Dynamics NAV Developer
Gold Star Foods INC
Ontario CA
——————————
——————————————-

[Ronald McVicar]

Yes as mentioned above definately have the SQL environment reviewed; and a partner with a solid NAV SQL / MVP really helps.   They Guys at Liberty Grove, Alex Cross, Inecta and Innovia any others are good at this. 

Do you have serialized inventory as that whole warehouse, inventory and serialization can really hammer your environment; and especially if you are shipping those serialized items.  Having an optimized SQL is essential and always has been.  And then if you have 3rd parties and / or enhancement in general as you might need index bad, not needed and turned off.  Some of these NAV / BC SQL resources have packaged SQL code that can be setup to evaluate and help you.  This can give you push back and documentation too.  especially if it get real bad.  We have Sales Order taking four hours to post at one time. 

At one place we needed to update / upgrade the infrastructure and for here mostly the SQL Server environment was being served by from older VMWare vSphere to Nutanix (but really needed updated resources)  as the disk storage was badly designed, no extra storage to add and / or memory.  SQL can need alot of room.  Our database for 45 NAV users was 450 GB and grew about 23GB monthly.  At the beginning inventory has 286,000 items (serialized mostly). 

Some NAV installs just never hit these walls and never see these challenges; but you can get through them and there is help in the NAV community.  Sometime reach out early rather than later.  Also, if you partner is having issues either figuring this out but good at every thing else that is ok.  It is ok to reach out and get a partner who acts more as consultant.  This can prevent a train crash or just help improve bumps in the road too.

——————————
Ronald McVicar, IT Software Mgr
NSP (Quality Meats)
nspproteins.com
——————————
——————————————-