SQL AX 2012 R2 lack of performance

(0) Share

Report

Posted on by Alessandro Giannetta

710

We are experiencing some lack of performance on SQL AX 2012 R2 machine, the machine allocate the total quantity of RAM memory to SQL. And we have to reboot our SQL AX 2012 R2 machine every day in order to reduce the RAM allocated to SQL.

Anyone knows if there is a parameter in order to resolve this problem?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Søren Rasmussen - B... 817 on at

Like (0)

Report

How much RAM have you assigned to the SQL server instance and how much RAM do you have all in all?

.søren

Was this reply helpful? Yes No
Verified answer

Cristián Cámpora G. 90 on at

Like (0)

Report

Probably is configured with fixed amount of memory. Check this article msdn.microsoft.com/.../ms178067.aspx

If you leave no room for S.O. memory results in poor performance since the S.O. or other app's can't do any operations on RAM and have to swap to disk which is very slow.

Was this reply helpful? Yes No
Verified answer

Malcolm Burtt 1,475 on at

Like (0)

Report
Hi

You should consider constraining the amount of memory that SQL Server can use for its buffer pool. I'm assuming that the machine in question is only running basic SQL Server and you dont have anything else that will need to consume significant amounts of memory (e.g. Analysis Services or Dynamics AX Application Object Servers).

I'd suggest that you leave at least 2GB of RAM for the OS and then allow SQL Server to consume the remainder but there is no way to give any hard and fast rules about this without more info about your system. You could look at Glenn Berry's article on suggested values for different system memory sizes at http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/ which should give you some sensible ideas.

You can configure the system to limit the buffer pool size as follows...

Open SQL Server Management Studio and connect to the database server

Right click on the Server node and select properties

Select the "Memory" page in the left pane

Modify the "Maximum Server memory" field (note that the value here is MB not GB so you need to be careful entering this)

You can do this while SQL Server is still running and it will gradually release any memory that it has acquired beyond the new limit that you have set although this make take some time depending on the machine workload at the time.

Regards

Malcolm Burtt

K3 Retail & Business Solutions

Blog: www.k3technical.com

Was this reply helpful? Yes No
Alessandro Giannetta 710 on at

Like (0)

Report

Thanks a lot!

Alessandro

Was this reply helpful? Yes No
Edwin Tjhai 290 on at

Like (0)

Report

Allocated a lot of RAM to SQL Server is not always solve your performance problems.

Disk I/O could be another factor.

Raid configuration

Just my two cents.

Was this reply helpful? Yes No