Learn Dynamics 365 Finance and Operations(Axapta)

This Article provides information about how to configure database and windows server for Microsoft Dynamics AX. To achieve optimal Microsoft Dynamics AX performance, we must correctly configure the database infrastructure.  You must have knowledge in following areas: ·           Windows Server administration. ·           SQL Server administration. Specific areas of knowledge include advanced configuration options, memory management, performance management, and troubleshooting. ·           Microsoft Dynamics AX system administration. Recommendation on Tune DB operations: # Recommendation Reference 1 Enabling trace flags 4136 ,1117 and 4199 on SQL server. T-4136 : Disable parameter sniffing T-4199 : Activate query optimizer fixes T-1117 : DB files growth 2 Disabling index hints from AX configuration and thereby allowing SQL to decide the best way to process the query. Best Practice 3 Making sure that entire table cache is not enabled

Sharing A very good post from Blog : http://shafeaa.blogspot.in/ First we are going to make sure that the AX prerequisites is installed.  Then we will start the installation process by installing the AX basic components which include  the Database,Application Object server, Client. Please Follow the steps bellow: 1- Open the Dynamics AX Media the double click the autorun.exe   2- when the Installer windows appear click the"Validate system requirements" to make sure that all prerequisites was installed. 3- Select the components that you attend to install. in our case we are going to select the Database,Application Object Server(AOS), and the client Component. then press the Validate Button. 4- Make sure that there is no errors then Click Finish. if any error appears you must fix it before continue. 5- Go back to the Installer main windows and click "Microsoft Dynamics AX Components". 6- Press next in the welcome screen. 7- In the licence