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 the latest MS SQL 2008 R2 installed on Windows Server 2008 R2 64-bit. The SQL server process never surpasses 1.5GB in the task manager resulting in heavy disk usage. I have solve this problem before in a 2003/SQL 2005 32bit environment by enabling PAE and AWE. I was under the impression that switching to 64-bit for everything will solve the 4GB memory limit.

share|improve this question
Does your server actually have more than 2GB of RAM installed and available? – Michael Hampton Oct 31 '12 at 0:11
Do you have any memory restictions configured on the SQL instance? Under "Properties" -> "Memory". I can confirm 64 bit SQL doesn't have trouble using avaiable RAM, here's a screenshot of two instances, one using ~48GB and one ~11GB. Also, have you been actively using this instance? Most RAM usage seems to come from query caching, and will be flushed at restart. – jscott Oct 31 '12 at 0:20
@TienTran: SELECT @@VERSION returns: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4266.0 (X64) <-- note the x64 – Greg Askew Oct 31 '12 at 0:49
I just noticed that its the Express version. Isn't that limited to 1GB ram? I'll install the full version to check. So sorry. – Tien Tran Oct 31 '12 at 1:20
@TienTran Ah, Express, yes, you're going to be limited. Please post that as an answer and mark it "accepted" when you are able. – jscott Oct 31 '12 at 1:52

Your Answer


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

Browse other questions tagged or ask your own question.