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 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
1  
@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
1  
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
1  
@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

 
discard

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

Browse other questions tagged or ask your own question.