Microsoft Dynamics 365 Blog


We now fully support database compression from within the AX system. If you are running Enterprise Edition, you can apply compression, which will save you Storage Space and decrease time for backup and restore.

Read about the feature in the links section below.


How to:

The form SysSQLSetup is used to set the compression and index options. This form can only be found in the AOT.

To set the right compression level Page or Row, please read the added link below.

Apply the settings on either All tables and indexes or individual selection.



In the form SysSQLAdmin, which can be found in the main AX menu (System Administration / Periodic / Database / SQL Administration)

we can apply the compression changes to all indexes or tables.





Apply only compression off hours or best in the implementation fase.




Data Compression: Strategy, Capacity Planning and Best Practices




Supported on:

SQL 2008 & SQL 2012 Enterprise

AX 2012


Author: Kim Truelsen

Date: 21/10-2012

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!