We help IT Professionals succeed at work.
Get Started

2008 64 bit server with SQL running at 95% memory

860 Views
Last Modified: 2012-05-09
We have a 2008 64 bit server running SQL that will consume 95% of available RAM.  We recently increased the physical ram by 4 GB, and it jumped back up to 95% utilization.  The server has 16gb of ram currently.  When checking with our DBA, he mentioned this..

"First the MAX and MIN memory has already been configured; been that way since the server came up.Currently, SQL is set to use just over 8.8 GB as a MAX and just under 1 GB as the MIN. My monitoring tool is confirming this is the case."

I ran some of the server diags included in 2008 and it is reporting that the sql service has a commit level of 17 gb.   Does that explain the high RAM utilization?  Is the system reserving 17gb of RAM for SQL even though the min and max memory has been set?

Please help me understand this.

THanks



ram.png
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE