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

Running SQL2008 R2 32bit on Windows Server 2003 Enterprise with 12GB of RAM. Inside the Memory settings of the SQL instance I've got max memory set to 10000MB but it isn't going past 1.6GB according to the following query.

SELECT object_name,counter_name,instance_name, (cntr_value/1024) as Memory_in_MB, 
    cntr_type FROM sys.dm_os_performance_counters 
WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')

Am I running into an issue due to the 32 bit OS/SQL install? Or do I need to configure something additional to allow it access to more than the 3GB? Windows is detecting 12GB.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

It's not 100% clear from you post; is Windows 32-Bit as well?

You will need to enable AWE in order to use the extra memory in a 32-bit environment.

share|improve this answer
    
Indeed, sorry. It is 32 bit. I did enable AWE but I'm still seeing 1.6GB as the target/total memory. EDIT: Just saw the bit about restarting the SQL service. I will try this after hours and report back. –  Justin Popa Mar 13 '12 at 18:38
    
Make sure you also grant Lock Pages in Memory to the SQL service account. That gets missed sometimes. –  squillman Mar 13 '12 at 18:55
    
That was it. Added the account to that policy and restarted SQL. Now using 8GB of RAM. Thanks :) –  Justin Popa Mar 14 '12 at 3:33
    
Good deal! Thanks for the follow up note! –  squillman Mar 14 '12 at 14: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.