Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

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


HP ProLiant DL380 G5
2 proc -2x QuadCore Intel Xeon E5450, 3000 MHz
Memory- 12288 Мб (DDR2-667 Fully Buffered ECC DDR2 SDRAM)


/3GB in the boot.ini. 
/PAE in the boot.ini. 
Enabled AWE in SQL Server.
Enabled Lock Pages in Memory Option for users SYSTEM and Local Service. 
Set Min/Max Memory to : 6 Gb/8 Gb

SQL Server: Memory Manager_Total Server Memory (KB) = 100%

I don't know how to make SQL capture free memory allocated him.

share|improve this question
Size of the databases on this server? – Mark Storey-Smith Feb 9 '12 at 19:31
up vote 3 down vote accepted

AWE memory can only be used for data cache. Things like procedure cache, workers stacks, execution memory grants, SQLCRL and so on can only use the process 'real' memory space (ie. the 3Gb). So even if you did set up everything correctly, it does not mean that 1) SQL Server will actually use all the 6Gb and 2) you won't run into out-of-memory issues despite plenty of AWE memory being available.

32bit is dead. Just move to a 64 bit environment and call it a day.

share|improve this answer
I can't replace on 64 platforms now. There is a program which uses a hardware lock on 32 bits (usb). ... It would be desirable to solve a question with memory SQL of the server on a platform of 32 bits – alexanko Feb 10 '12 at 9:09

remove the /3gb switch and use /pae and awe. See this:

share|improve this answer
I just observed that your server has less than 16 gb RAM. Please disregard my answer, sorry. – RK Kuppala Feb 9 '12 at 19:15

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.