Tuning Dynamic AX 2012 and SQL Server 2008 R2

This question has suggested answer(s)

Hi All !

Well, I have a little issue. Before, I have SAP/Oracle, now I have Dynamics AX 2012 with SQL Server 2008 R2. All runs ok, except the time to treat the different batches (data import, extraction, transformation, indexation ...). My DB is about 1,2 TB.

I respect all the requirements from MS, but I want to know if there are white papers, best practices, blogs feedback on tuning SQL Server 2008 R2 with Dynamics Axapta 2012 about batches treatment, import data, indexes .... with the same volumetric on SAP/oracle, I have 3 hours of treatments with the couple Dynamics / SQL Server 2008 R2 SP1 , i have more than 9 hours, ....

If you have some ideas ....

Have a nice day !

Best Regards!

RHUM2

 

All Replies