The problem

As I had an issue with the performance I wanted to create indexes without DATAREAID in Dynamics AX 2009.

The indexes didn’t have the DATAAREAID column which is automatically added to the index as the first column on creation.

Because the newly created indexes shouldn’t have this column in the first position I had a problem.
The second problem is that every time an update or synchronization takes place in Dynamics AX 2009 the database objects which are not part of the software architecture are removed.

I was very interested in the new features of SQL 2008, especially the Resource Governor.

By implementing the Resource Governor you need to calculate the maximum shared and the calculated maximum. In the MSDN documentation “Resource Governor Concepts”, Microsoft explains how this can be calculated.

Because I like to let computers do as much for me automatically as possible I created an Excel document that calculates the values for you.