Determine whether an MS SQL database instance has enough memory allocated to it

Hi Experts,

Is there a way to determine whether an Microsoft SQL database instance has enough memory allocated to it? / determine whether the memory on a database instance should be increased?
I.e such as an query or tool that can be run

Thanks
sherlock1Asked:
Who is Participating?
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.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes, you can do it with Perfmon traces and Check the nice article by Brent Ozar to have this started out..
https://www.brentozar.com/archive/2013/09/how-to-prove-your-sql-server-needs-more-memory-video/
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Run the DBCC MEMORYSTATUS command to have the information about a SQL Server instance is using the memory. If you find any memory bottleneck then you'll know how much RAM it will be needed to be add.
0
sherlock1Author Commented:
Thanks experts for your feedback. In regards to the
DBCC memory status command are there any figures in particular that should be focussed on?

The SQL server is a VM (running in Vsphere) and has 8GB allocates to the database instance

Does an instance always try to use all the memory allocated to it?

I believe at the Windows OS server level sql server grabs as much memory as it can?

Thanks
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
SQL Server by design will take all the Memory available in the Server unless otherwise you have limited by configuring the Max Server Memory.
This is done for better performance of SQL Server.
So, to answer your original question you can identify the Available Memory and Memory grants pending and then decide whether to increase your Server Memory or not.
or else you can simply configure Max Server Memory so that OS and other operations can run fine.
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
sherlock1Author Commented:
Thanks a lot for all for your help.
Im not sure what the results of the dbcc-memorystatus show / what columns/figures I should look for. I have opened a new questions here: https://www.experts-exchange.com/questions/29091776/dbcc-memorystatus-results-main-columns-results-to-check.html#questionAdd

if either of you are able to help on that question that would be great
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
SQL

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.