We help IT Professionals succeed at work.
Get Started

DB Server Slow down in AX

239 Views
Last Modified: 2016-01-27
Dear Experts,

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
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
Any help how we can fix this problem happening permanently.

Regards
Asif
Comment
Watch Question
Owner\Director
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE