we run an on-prem version of Dynamics AX. We would like to improve performance by implementing some of the recommendations from the Missing Index report generated by SQL Server Management Studio.
Our problem is that once we have selected a specific index to implement based on its overall score and our own judgement we want to be able to develop a test plan to measure how adding this index speeds up a specific user operation inside AX (e.g posting a journal, regenerating the trail balance, or oping the sales line detail report).
In order to measure the before and after impact of adding the index we first need to identify which AX operations or user actions need the index. We do not know how to do this!
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
490
