Two stories about inventory closing and SQL Locks

Story #1: update_recordset considered harmfull. Recently, I was invited to a customer who had started to use Inventory Closing functionality about a month ago. They were using DAX2009 with recent rollup 7. Every time when they were running inventory closing, the system locked all (or at least – most of the) inventTrans records, safely preventing […]

Multithreaded MRP and related issues

Today, I will share some experience related to setting up and fine tuning MRP for best performance. The most significant MRP-related improvement of DAX2009 over older versions is an ability to execute MRP in multi-threaded mode, when planning process is spread over several independent processes executed in parallel. As usual, multi-threaded execution works only when MRP is executed in […]