Dynamics Ax 2012 History cleanup

On of my most popular posts is Cleaning up the AIF document log, but this is not the only table that could benefit from a regular cleanup. For some of these standard tables there are little or no cleanup jobs, as an example the cleanup for the AIF document log only runs online in the client… Continue reading Dynamics Ax 2012 History cleanup

Dynamics Ax 2012 my ideal Azure VM setup

Introduction This is just a quick note on how I setup an Ax 2012 on an Azure machine to get the most bang for my buck. The example I’m using is a DEV machine where I keep the sample code for this blog. But you could apply the principles for every environment. Sizing & disks… Continue reading Dynamics Ax 2012 my ideal Azure VM setup

Dynamics Ax 2012 fill factor

Database synchronize We all know that Dynamics Ax constructs its tables and indexes during a DB synchronize, and if we would make changes directly in SQL these could be overridden by Ax when installing model updates and syncing those to the database. But there’s more to creating an index then the defaults Ax does and… Continue reading Dynamics Ax 2012 fill factor

Dynamics Ax 2012 Trace parser with ETW

Hi All, The following subject already exists for a while but I found it so useful that I want to get it out there once more! Lets consider the following scenario: There’s a performance issue in production and no other environment around where the customer or the partner is able to reproduce it or the… Continue reading Dynamics Ax 2012 Trace parser with ETW

MS SQL Server index maintence

Hi, As we all know index maintenance is important especially on large Dynamics Ax databases, but often I see installations where there are little or no maintenance plans or all kinds of exotic scripts. Therefor I want to show you guys the SQL Server Maintenance Solution by Ola Hallengren, this does not only contain stored procedures for… Continue reading MS SQL Server index maintence