Cleaning up cross-reference DB

Development VMs for Dynamics 365 for Finance and Operations come with a cross-reference database that doesn’t match the actual code and metadata. There are many annoying references to Microsoft’s own test models, which aren’t included and therefore such references are useless and make finding real references more complicated. (The idea to get it fixed is …

Continue reading ‘Cleaning up cross-reference DB’ »

Index fragmentation on xRef tables

Building cross-references for code in Dynamics AX creates millions of records in xRef tables. It has also very negative impact on fragmentation of database indexes. This is an example of indexes on xRefReferences table from a customer’s environment after rebuilding all cross references. And here the same set of indexes a few minutes later after …

Continue reading ‘Index fragmentation on xRef tables’ »