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.