My Server is a Child Domain with Windows Server 2003 EE and SQL Server 2005(Devp. Edition). Recently, I have upgraded the server RAM from 4GB to 16GB. I have the following setting for SQL to utilize the additional memory available. 1. Given rights of 'Lock pages in memory' to the Administrators through Domain Controller Security Policy and Domain Security Policy. 2. Enabled AWE in SQL Server 3. Set the Min memory to 0 and Max Memory to 10240 MB (since I want to use 10GB only now). 4. Set 'Maximum Data throughput to network applications' in the LAN properties 5. Increased the PageFile Size 6. Put the switch /3GB and /PAE in boot.ini file. Inspite of all the above setting, SQL still does not use more than 2.75 GB of RAM (as seen in Task Manager). Please tell me, How can I make SQL utilize 10GB of the available 16GB of RAM. And also when I view DBCC memorystatus it shows AWE Allocated as 0. Thanks in advance.
Memory allocation in SQL Server is not reported properly in Windows when using AWE. You need to take a look at [`sys.dm_os_process_memory` (BOL)], this will report memory usage inside SQL Server. SELECT physical_memory_in_use_kb, -- How much memory is being used locked_page_allocations_kb, -- How much is locked by SQL Server (using AWE) total_virtual_address_space_kb, -- Virtual address space size virtual_address_space_reserved_kb, -- reserved VAS virtual_address_space_committed_kb,-- used VAS virtual_address_space_available_kb -- reserved minus used VAS FROM sys.dm_os_process_memory :
Dbcc memorystatus Check for awe allocation Update, seems that your machine is not picking up AWE; make sure the /PAE option is the only one in the boot.ini and go from there. This is the memory utilization that an X86 with AWE should show (in the 200s KB by default): ![alt text] : /upfiles/AW.png
It seems AWE was not configured properly... My problem was finally resolved by reconfiguring AWE and restarting the SQL Service... Thanks all, for your guidance and support. It was of great help to me... Thanks again...