Provide more memory for SQL Server

A friend called me today to ask me about the maximum supported physical memory capacity of the Windows Server 2003 32bit Enterprise Edition, mainly because the server is running a database server with a memory usage of 2G, and servers are very inefficient. Intend to extend memory for SQL Server To provide more memory.

Confirmed that the server is the HP G3 series support PAE, that is, the physical Address extension, the server should be the largest support 32GB, while the Windows Server 2003 32bit Enterprise version of the largest support 32GB, in order to be able to effectively use the memory on the system need to open the/PAE parameters, but to make the SQL Server uses more than 2GB of memory to enable AWE memory. To do this you need to execute the following script in SQL Server Query Analyzer:

sp_configure ‘show advanced options’,1

reconfigure

go

sp_configure ‘awe enabled’,1

reconfigure

go

sp_configure ‘max server memory’,6144

reconfigure

go

Note: If you use the/3GB switch in the Boot.ini file, SQL Server can use up to 3GB of memory.

Now look back and learn more about the maximum supported memory capacity of Windows Server 2003 and other hardware support information for later reference.

Windows Server 2003 R2 Standard Edition

Up to 4 processors, Max 4GB of RAM

Windows Server 2003 R2 Enterprise Edition

Up to 8 processors, x86 architecture Max 64GB memory, x64 architecture Max 2TB Memory

Windows Server 2003 R2 Datacenter Edition

x86 architecture up to 32 multiprocessor, Max 128GB memory, x64 architecture up to 64 multiprocessor, Max 2TB memory

Windows Server 2003 Web Edition

Max 2GB Memory

Windows Server 2003 Standard Edition

Up to 4 processors, Max 4GB of RAM

Windows Server 2003 Enterprise Edition

Up to 8 processors, x86 architecture Max 32GB memory, x64 architecture Max 64GB Memory

Windows Server 2003 Datacenter Edition

Up to 64 multiprocessor, x86 architecture Max 128GB memory, x64 architecture Max 2TB Memory