0

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?

GregD
  • 8,753
adan851018
  • 3

2 Answers2

0

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

Mark Sowul
  • 1,859
-1

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.

Ignacio Vazquez-Abrams
  • 47,271