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 !
Did you check the Dynamics Ax Performance Team blog?