Blog

Maintaining your Dynamics Ax indexes

Please read the following blog related to maintaining indexes in Dynamics Ax:http://blogs.msdn.com/b/axinthefield/archive/2012/08/01/database-maintenance-strategies-for-dynamics-ax.aspxI added on more join to the following script in order to find where the indexes come from:...

Shrinking the transaction log

At some point, specialy if you don't give regular mainteinance to your Ax database, the transaction log will be huge. We followed the article http://support.microsoft.com/kb/907511 to reduce the log size and it worked perfectly. Some things to consider for setting the log file is to set it to autogrow and to give a fixed increment size (100 MB for example.) The reasons that could make your lo...

Back to Blog

© 2017 Dynaxti, inc. All rights reserved.

Navigation

Social Media