SQL Server 2014 STD not using available memory

dgerler
dgerler used Ask the Experts™
on
We are in the process of building a new MS Dynamics GP server. We have installed windows server 2016 std and SQL server 2014 std. and Dynamics GP 2016. We have set the maximum memory in the Server properties to 60GB out of t he 64GB RAM "installed" in  this VM.

We are currently upgrading the databases from GP 2015 to GO 2016 SQL Server and the OS and SQL Server are only using 5 GB RAM and the GP Expert thinks it should be using much more RAM at this point.

Can anyone give me some ideas on what to check for why SQL is not using much more RAM?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
SQL Server grabs the memory only when its needed and will keep it for itself till the maximum memory settings you have configured. As far as sql server 2014 std edition is considered, it could allocate upto 64GB RAM.
Senior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
How did you determine the amount of RAM used by SQL?  Be aware that Windows processes/methods are not fully aware of how much RAM SQL is using.


We have set the maximum memory in the Server properties to 60GB out of t he 64GB RAM "installed" in  this VM.

I think that's too aggressive.  You should drop it down to 56GB at max, definitely to start out with.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017
Commented:
SQL Server are only using 5 GB RAM and the GP Expert thinks it should be using much more RAM at this point.
How did they realize those 5GB?
The only way to know how much memory a SQL Server instance is using is by running DBCC MEMORYSTATUS inside the respective SQL Server instance.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
dgerler, a feedback will be appreciated.

Author

Commented:
Thank you. It was really an overall usage of RAM including the OS. It ended up the problem was the application was running very slow because of Antivirus scanning everything. It seemed like the RAM usage should have ramped up faster and did eventually. We fixed the antivirus issue and the application completed as expected.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial