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?
dgerlerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
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.
0
Scott PletcherSenior DBACommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
dgerler, a feedback will be appreciated.
0
dgerlerAuthor 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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2016

From novice to tech pro — start learning today.