X86 Server enable AWE still can only use 2GB memory?

Question

hi, all,

My uat Server, 32 bit system, windows server entrerise +SQL Server 2008 enterise r2, totally got 16GB memory, i configure maxinum server memory 13GB, enable AWE, restart SQL Server services, but from the performance monitor, the Target Server Memory only show 1572480 kb(1.5GB),  help me pls.

Regards

Garey

Answer 1

Hi Garey,

two things:

If there is not a lot of action going on, the counter could infact be low. It will progress . When did you check, right after reboot?

Second, How did you enable AWE?

regards,

Edward

Answer 2

Try to enable the /3GB /PAE switches in your boot.ini and reboot.

Or even better, upgrade to 64 bit and not waste time on legacy limitations.

---

Henrik Fyhn http://repeatableread.blogspot.com/

Answer 3

The Memory architecture is different B/w 32 and 64 bit, since in your case is 32 Bit -you need follow the below steps incase if you need to allocate more than 4GB or etc..

If your SQL required to use more than >4GB(ex:)(then you need to Enable the /PAE switch in the boot.ini file in the OS,i) then to utilize on SQL then

you need perform the below steps-

Enable the Locked pages Policy for the SQL server service accounts-

1.How to Enable  the Lock pages in Memory option-

http://msdn.microsoft.com/en-us/library/ms190730(v=sql.90).aspx

Then you need to Enable the AWE on SQL level-

2.http://msdn.microsoft.com/en-us/library/ms190961(v=sql.90).aspx

http://msdn.microsoft.com/en-us/library/ms190673(v=sql.90).aspx

then to verify whether the AWE enabled or not propery you can check in the SQL server error log-.

so for additional information of Memory architecture in 32 bit then please refer the link-

http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

AlsoA) In your case still it is showing 2GB Means then you need to verify whether the locked pages/AWE enabled or not properly.

B)if you are going give SQL to utilizae 3GB then -verify boot.ini ( you have /3GB switch) if you are going to use more than 3GB then you can see /PAE switch.

---

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and unmark them if they provide no help.