This post is more than 5 years old
1 Rookie
•
16 Posts
0
14923
May 13th, 2014 14:00
RAM Requirement Info Needed
Hi Experts
We have a R720 system with 32GB RAM and one ERP software is running on it. The task manager shows that CPU reaches 93%-97% every second and then comes back to 0% and it keeps doing this all the time. Out of 32721MB of RAM, only 521MB is free and during busy hours, it becomes 0. Page file is 32428M / 65658M. Resource Monitor shows that 25% of CPU time is being used by SQL Server.
Are these symptoms showing that we need to increase RAM in server?
0 events found
No Events found!
DELL-Josh Cr
Moderator
•
9.6K Posts
•
42.1K Points
0
May 13th, 2014 16:00
Hi,
Are you seeing performance issues? SQL server tends to use up as much memory as it has available. Are you running other applications as well on the server? More memory may help with the available memory going to zero, but the CPU usage being that high won’t be changed. It might be better to split the load on this server to two servers.
Aftab24
1 Rookie
•
16 Posts
0
May 13th, 2014 17:00
Hi,
Till now, we don't have any performance issues. But we are just curios about server health.
Right now we have 4GB RAM chips in A1, A2, A3, A4, B1, B2, B3, B4 slots. The new purchased RAM chips are 8GB Sticks and there are 4 pieces. How we should arrange them in the server?
Regards
theflash1932
11 Legend
•
16.3K Posts
0
May 13th, 2014 20:00
Also, if you decide to upgrade the memory, keep in mind that if you are using Windows Server Standard Edition, you will be limited to 32GB of RAM.
theflash1932
11 Legend
•
16.3K Posts
0
May 14th, 2014 07:00
You're right Dev ... for some reason I thought he had an older system - even the R710 (depending on its age) would likely have shipped with 2008R2. The 32GB limit in Standard has been a big gotcha with modern servers that hold so much RAM, but if you are running 2012+, then you're fine.
Dev Mgr
6 Operator
•
9.3K Posts
0
May 14th, 2014 07:00
With Windows 2012 (and 2012 R2), Windows Server Standard supports up to 4TB of RAM.
SQL will use every GB of RAM you put in the server, so seeing your RAM (near) maxed out is not unusual. I don't know about the CPU usage spikes, but if your performance is acceptable, the memory usage isn't a concern.
Source: http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778%28v=vs.85%29.aspx
Aftab24
1 Rookie
•
16 Posts
0
May 14th, 2014 13:00
Hi Dev and TheFlash
We have Windows Server 2008 Enterprise.Will it support 64GB RAM?
theflash1932
11 Legend
•
16.3K Posts
0
May 14th, 2014 13:00
I believe it is 1TB in 2008 Datacenter and Enterprise - 2TB in 2008R2 Datacenter and Enterprise.