Looking for a way to list index fill factor settings configured in Dynamics AX 2012 R2

(0) Share

Report

Posted on by CrisAtMKETool

Hi. Thanks in advance for your help. We came across a situation where the fill factor settings for certain indexes did not match what the SQL server had. In this case, working with the DBA, we want what is listed in SQL server. Found the issue during a code deployment when synchronizing the Data Dictionary. The fix was to manually change AX, but I would really feel better if I could audit the AX settings and compare to what is in SQL. I have a query to pull the settings from SQL Server, but I'm looking for a way (without manually looking through 600+ indexes in the AX client) to list the indexes and fill factor settings as AX sees them?

*This post is locked for comments

I have the same question (0)