Why not to touch AX DB directly

I’ve been asked to reiterate some arguments against direct access to AX business data. (As you all know, the recommended approach is always going through AOS, such us calling web services.) Here are some of the arguments: You would bypass all business logic. It often means that you would have to re-implement some AX logic …

Continue reading ‘Why not to touch AX DB directly’ »

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’ »