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 Windows 2008R2 Web server running SQL 2008R2 Web 64-bit. The server has 8GB of memory installed. See this from SSMS:

My Server

In the SSMS management interface, I am unable to configure the server to use more than 2GB of memory. I've considered just issuing a sp_configure and see what happens, but I'm a bit flummoxed at the fact that the interface doesn't want to let me assign more than 2GB, so I'm not doing that, yet.

Can't go above 2GB

I can enter a larger number in the box, but it just goes back down to what's shown there.

This server is a small shared hosting server; I'd like to give SQL Server 4Gigs and see how that looks; maybe give it more. Any ideas? Should I just go ahead and do a sp_configure and ignore the silly GUI?

share|improve this question
I'm also assuming because it's 64 bit, the AWE box should remain unchecked. – Andrew Barber Feb 28 '12 at 6:23
Per squillman's answer below, I feel really foolish. Doubly so because the window I've included a screen shot of clearly says the value is in MB! D'oh! – Andrew Barber Feb 28 '12 at 6:27
Correct. You don't need AWE with 64-bit. – squillman Feb 28 '12 at 6:28
up vote 2 down vote accepted

What value are you putting in the max server memory box? (I'm assuming you are using an account with sysadmin or serveradmin privileges)

If it continues to give you problems I'd just forget about it and use sp_configure like you say. That's what the GUI will do, anyway. If that gives you problems then at least you should be able to see what the error message is. Don't forget to run reconfigure afterward to apply the change.

share|improve this answer
I was trying to put double the current value, and noticed as soon as the box loses focus, it changes back. The up/down selector is capped there, too. And yup, I'm trying to do it as an admin. (I can set it to a lower value via that box, for instance). – Andrew Barber Feb 28 '12 at 6:22
The value is in MB so for 4 GB max memory you should enter 4000 into that box. – squillman Feb 28 '12 at 6:23
Oh!!! Ok, now I feel foolish! Although, I'm glad I included that photo! – Andrew Barber Feb 28 '12 at 6:25
Hey, we alllll been there :) – squillman Feb 28 '12 at 6:26

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.