Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SQL Server 2008 R2 x64 instance. I tried to change the Minimum and Maximum memory to 60 MB and 2000 MB using Management Studio (Server Properties->Memory). When I close and reopen Management Studio I see those values still there. However, when I restart the SQL service, I go back to the Server Properties in Management Studio and I see that both Minimum and Maximum memory are now set to 4091 MB.

Is SQL Server changing those values by itself?

Thanks in advance for your help!

share|improve this question
up vote 0 down vote accepted

SQL doesn't change those values for you. Just to rule out the obvious, are you sure you're looking at the same SQL instance where you're looking at it the second time?

On the SQL instance in question, run this and see what the values are for in the config_value column for min server memory (MB) and max server memory (MB)

sp_configure "show advanced options",1
share|improve this answer
Thanks, it looks like another application was setting the memory settings. – Juan Tarquino Aug 26 '10 at 13:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.