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

Tengo un servidor con 8GB de RAM de 32 bits, instale windows server 2003 enterprise y sql server 2005 enterprise, el Sistema Operativo reconoce los 8GB, pero el Sql Server solo usaba 1.6 GB de memoria, entonces agregue al boot.ini el parametro /PAE y en Sql Server le habilite AWE de 1GB a 5GB, despues de reiniciar el servidor el Sistema que usa la BD estaba mas rapido mejoro bastante, pero en memoria el Sql Server solo usa 100 MB, veo la cantidad de memoria usada en el Administrador de Tareas de Windows, y no se si esta funcionando AWE o que sucedio?

Rough translation:

I have a server with 8GB of RAM 32-bit, install windows server 2003 enterprise and sql server 2005 enterprise, the operating system recognizes the 8GB, but the SQL Server only using 1.6 GB of memory, then add to boot.ini the parameter / PAE and will enable AWE Sql Server 1GB to 5GB, after rebooting the server using the database system was faster, the better lot, but in memory the SQL Server only uses 100 MB, I see the amount of memory used in Manager Windows Tasks, and not if AWE is running or what happened?

share|improve this question

2 Answers 2

up vote -1 down vote accepted

AWE/PAE increases the amount of physical system memory to a theoretical maximum of 64GB, but the amount of virtual process memory is still hard-restricted to 4GB.

share|improve this answer
    
look in the windows task manager performance tab USE OF PF is consuming 5.65 GB, is that the AWE is working correctly? or should not appear there? –  adan851018 Dec 24 '10 at 1:33
    
That's the page file (swap space). The value that matters for seeing if PAE is working is the available physical memory. –  Ignacio Vazquez-Abrams Dec 24 '10 at 1:36
    
Said Physical memory (KB): Total: 8383532 Available: 2311468 System Cache: 2593864 –  adan851018 Dec 24 '10 at 1:40
    
Why did I say "available" when I clearly meant "total". Yes, looks like PAE is active. –  Ignacio Vazquez-Abrams Dec 24 '10 at 1:48
    
Thank you very much! –  adan851018 Dec 24 '10 at 1:50

Run dbcc memorystatus on the SQL server; AWE memory does not show up in a process's working set (and thus task manager). See also: http://msdn.microsoft.com/en-us/library/ms191481.aspx

share|improve this answer

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.