<div>
Can you confirm patch level of SQL and which version of AX and also patch level please
</div>


<div>
This is either QueryPlan cache or ToeknAndPermUserStore cache built. &nbsp;Has been known to make even the simple quick query into a performance nightmare.
</div>


<div>
Hi,<br />
<br />
SQL server 2008 R2 and AX 2012 if this help.<br />
<br />
Regards
</div>


<div>
This is QueryPlan cache or ToeknAndPermUserStore cache built. <br />
<br />
Need a maintenance script running regularily to keep this in check without flushing the cache unless neccesary.
</div>


<div>
Hi Damon,<br />
<br />
Please can I have nay KB of bit Explanation of this so I can understand in depth about this.<br />
<br />
Regards
</div>


<div>
Hi,<br />
<br />
please email me on <br />
<br />
ramay_aku@hotmail.com<br />
<br />
Thanks
</div>


<div>
Hi Damon,<br />
<br />
Please looking forward document from ur side on my email address.<br />
<br />
Ramay_aku@Hotmail.com<br />
<br />
Thanks
</div>


<div>
Hi,<br />
<br />
Another setting that pays to change from the default with almost no downside is the optimise for ad hoc queries.<br />
<br />
<a href="https://msdn.microsoft.com/en-us/library/cc645587.aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/cc645587.aspx</a><br />
<br />
HTH<br />
&nbsp; David
</div>


<div>
The documnet provided is good enough to do the Job
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
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. <br />
We have tried to figure out why it is happening but could not found any solid reason.<br />
As this happen we run the following command which speedup the AX <br />
DBCC FREEPROCCACHE<br />
DBCC DROPCLEANBUFFERS<br />
Any help how we can fix this problem happening permanently.<br />
<br />
Regards<br />
Asif
</div>
</div>


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

DB Server Slow down in AX

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.