Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

Set: /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

SQLServer: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
add comment

2 Answers

up vote 2 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
add comment

remove the /3gb switch and use /pae and awe. See this: http://blogs.technet.com/b/beatrice/archive/2008/08/29/3gb-pae-and-awe-taking-away-some-confusion.aspx

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

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.