Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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
reconfigure
GO
sp_configure
GO
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

 
discard

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.