SQL Server provides more memory solutions

If you are not familiar with how to provide more memory for Oracle SQL Server, the following article introduces the actual operation steps for implementing Oracle SQL Server to provide more memory. If you know it, it will play an important role in actual operations, the following articles describe related content.

Today, a friend called to ask me about the maximum physical memory capacity supported by Windows Server 2003 32bit Enterprise Edition, mainly because the memory usage of a database Server in operation reaches 2 GB, the Server is very inefficient and intends to expand the memory to provide more memory for SQL Server.

After confirmation, the servers are HP G3 series that support PAE, that is, physical address expansion. The Server should support a maximum of 32 GB, while Windows Server 2003 32bit Enterprise Edition supports a maximum of 32 GB, to effectively use memory on the system, you must enable the/PAE parameter, and enable AWE memory for SQL Server to use more than 2 GB memory. Therefore, you need to execute the following script in the Oracle 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 the/3 GB switch is used in the boot. ini file, Oracle SQL Server can use up to 3 GB of memory.

Now let's take a look at the maximum memory capacity supported by Windows Server 2003 and other hardware support information for future reference.

Windows Server 2003 R2 Standard Edition

Up to 4 Processors, up to 4 GB memory

Windows Server 2003 R2 EntERPrise Edition

A maximum of 8 processors, a maximum of 64 GB memory for x86 architecture, and a maximum of 2 TB memory for x64 Architecture

Windows Server 2003 R2 Datacenter Edition

X86 architecture supports a maximum of 32 multi-processors and a maximum of 128 GB memory. x64 architecture supports a maximum of 64 multi-processors and a maximum of 2 TB memory.

Windows Server 2003 Web Edition

Maximum 2 GB memory

Windows Server 2003 Standard Edition

Up to 4 Processors, up to 4 GB memory

Windows Server 2003 Enterprise Edition

A maximum of 8 processors, a maximum of 32 GB memory for x86 architecture, and a maximum of 64 GB memory for x64 Architecture

Windows Server 2003 Datacenter Edition

A maximum of 64 multi-processor, 128 GB memory for x86 architecture, and 2 TB memory for x64 Architecture

The above content is an introduction to how to provide more practical memory operations for Oracle SQL Server.