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
InventSumrow 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.