40
Hi all
Our AX 2012 R3 system has been running for about 3 years. The Inventtrans table has grown immensely . I have ran the on-hand entries cleanup but it does not really make a difference.
Is there any other way to shrink the rows in this table (it is sitting over 9mil)
Here is a checklist for poor performing reports in AX:
Start by analyzing the query:
1. Do the joins in the query make sense?
2. Are all of the table in the query resulting in index hits when executed, or are there table scans?
3. Are there missing indexes requested by the index advisor? If so, evaluate the difference.
Are the reports written in best practice?
1. Query returns filtered results, not using the report to filter the results, when avoidable.
2. Should the report be converted to RDP if query is expensive?
These should send you down the right path. Chances are high the 9 million rows in InventTrans is not your performance problem.
Hello Neilb22,
Are the reports that face those performance issues standard reports or customized ones?
If they are customized ones, you might probably be able to check and 'tune' the way how they extract the data.
Alternatively, you can use BI tools for analyzing those inventory data.
Best regards,
Ludwig
Hi Neilb22,
A small additional comment to the important notes already given above. The Inventory transactions are referenced throughout the system. When you perform a consistency check, it will verify the InventTrans table with the InventSum table. When you delete records, you cant use the consistency check anymore and an option to repair the InventSum table in case of emergency is lost.
Hi Neilb22,
The inventtrans table is a table that you should almost never touch because a lot of things depend on those transactions.
Unless you see a huge performance issue, I would recommend not trying to do any kind of cleaning, correction or something else because it is one of the main / central tables in AX.
Best regards,
Ludwig
Do you experience some issues because of the size of the table?
9 million doesn't sound huge.
Are you planning to upgrade to D365 in the coming years? If yes, you could just leave old transactions behind in the upgrade, and migrate only master data and opening balances to D365.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (