D365 : PERF_INVENTDIM_INVENTSUM, and PERF_INVENTDIM_WHSINVENTRESERVE

If you look into where your DB is going, then in some cases the following two views pop’s up as occupying quite a lot of space:

PERF_INVENTDIM_INVENTSUM, and PERF_INVENTDIM_WHSINVENTRESERVE

At one customer they took :
AXDB.PERF_INVENTDIM_INVENTSUM 106.74 GB
AXDB.PERF_INVENTDIM_WHSINVENTRESERVE 96.33 GB

In 2021 -> 2022 Dynamics 365 went trough some major inventory performance redesign introduced around version 10.0.25–10.0.27. Eliminating the need to join InventSum ↔ InventDim for most queries Improved on-hand calculation performance, especially for:

  • Reservation hierarchy queries (WHSInventReserve)
  • Recalculation jobs (InventSumRecalcItem)
  • On-hand queries via InventOnHand* views
  • Simplified indexes: Each denormalized InventSum row now carries its own dimension attributes.

But in the process of improvements, there where some workflows that created these tables. But they are of no use any more.

Just create a support case, and Microsoft will remove them, and you regain your Gig’s πŸ™‚

Hopefully Microsoft will also flush out these views in a future update.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.