We have DB server (SQL Server 2008 R2) running Dynamic AX. The server is hosted on VM ware having 64 GB RAM and etc. But for some reason once or twice in every day we are experiencing Slowdown or AX which cause serious problem for logistic department to ship the order.
We have tried to figure out why it is happening but could not found any solid reason.
As this happen we run the following command which speedup the AX
Any help how we can fix this problem happening permanently.