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
