How to assign more than 2GB memory to the SQL Server 2008 R2 Web Instance

memorysql-server-2008-r2windows-server-2008-r2

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?

Best Answer

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.

Related Topic