Avatar of David Gerler
David Gerler
Flag for United States of America asked on

SQL Server 2014 STD not using available memory

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?
Microsoft SQL ServerMicrosoft DynamicsWindows 10AzureWindows Server 2016

Avatar of undefined
Last Comment
David Gerler

8/22/2022 - Mon
Aneesh

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.
ASKER CERTIFIED SOLUTION
Scott Pletcher

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Vitor Montalvão

dgerler, a feedback will be appreciated.
David Gerler

ASKER
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy