Microsoft Dynamics Ax | 365. Tips, tricks, tutorials and fixes

Introduction In this post, I try to describe performance issues regarding on-hand activities that I faced on different clients and a way how I handled it. Based on detailed performance analysis, I found out that SQL server generates bad query execution plans regarding the joins of InventSum and InventDim tables and it’s a commonly known issue that called “ parameters sniffing ” issue. We had many cases randomly when such queries stopped the process of whole company,  ☹  and it could be once a week, once a month, many times a day. Pre-steps Before changing or adjusting these functions, please make sure that the next clean-up jobs are scheduled from Inventory and Warehouse Management modules (Periodic/Clean up). Based on my experience (these jobs can be a root cause of DB locks during executing and I’ll describe it later in another post), these jobs have to be scheduled one by one in one batch job as a batch task. Also please make sure that you have  KB  ...