I love this quote: 🙂 We were treating SQL Server as a relational database. What I learned is that it’s really not. It’s a software abstraction layer over disk I/O. If you don’t know what’s happening at the disk I/O layer, you don’t know anything. (Brian Harry about TFS scaling)
When using delete actions in Dynamics AX, don’t forget that AX will have to look into database to know if there is any related record. And if there is no index, the performance can be really bad. I’ve just run into such a case, when deleting a customer executed a query running for six seconds. …
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 …