AX 2012 Column Includes and Table Partitioning

(0) Share

Report

Posted on by joederoche

725

We have a client that is doing a fairly large (gloabl) implementation of Dynamics AX 2012. Their DBA came to me with some questions in regards to performance tuning SQL 2008 R2 with respect to the databases for the AX application. He wanted to if there was a way to perform the following functions, and if so how:

1. Add include columns to an index on a table within the application. I didn't see a way to do that from the AOT, and if it is done in SQL (not recommended), the next time the DB is synchronized, those changes will be removed.

2. Is there a way to partition the tables and/or indexes and place them in different file groups on different disks so that the performance could be enhanced from a data retrieval and index seek perpsective.

Thanks,

Joe

*This post is locked for comments

All responses (2)

Answers (0)

Margo Crandall on at

Like (0)

Report

Re: AX 2012 Column Includes and Table Partitioning

Hi Joe,

We do not recommend that you partition tables. The most effective way to alleviate IO pressure is to increase the number of drives used by the AX database, use the correct RAID level, and follow documented Best Practices. Please see the topic Configure SQL Server and storage settings for AX 2012 and the Database Configuration Whitepaper for AX 2009.
Daniel Weichsel 1,657 on at

Like (0)

Report

Re: AX 2012 Column Includes and Table Partitioning

You can create included columns for indexes in AX 2012. After adding the field to an index, set its "IncludedColumn" property to Yes.