Enable SQL Server 2000 to support more than 2 GB of memory

To:Http://yiyeweichen.ycool.com/post.2856405.html

To enable SQL Server 2000 to support a large memory of more than 2 GB, perform the following operations:

1. Enable the PAE mode of the Operating System
Add/PAE to the boot. ini file:
[Boot loader]
Timeout = 30
Default = multi (0) disk (0) RDISK (0) Partition (2) \ WINDOWS
[Operating systems]
Multi (0) disk (0) RDISK (0) Partition (2) \ Windows = "Windows Server 2000"/fastdetect /PAE
Refer: Windows Server 2003 and Windows 2000 support large memory

2. Enable the awe mode of sqlserver and set the maximum memory usage to 6 GB.
Sp_configure 'show advanced options', 1
Reconfigure
Go
Sp_configure 'awe enabled', 1
Reconfigure
Go
Sp_configure 'max Server Memory ', 6144
Reconfigure
Go
Refer: How to configure SQL Server to use more than 2 GB physical memory

3. Set the Memory Lock page
. on the taskbar, click Start, and then click Program ".
B. Click "Administrative Tools" and select "Local Security Policy ".
C. Expand "Security Settings" and "Local Policies", and then click "user permission assignment ".
D. On the right-side screen, right-click "Memory Locking page" and click "security ".
E. in the Local Security Policy Settings dialog box, click Add ".
F. Click to select the account that runs the MSSQLServer Service (generally administrator ).
G. Click OK ".
Note: if you do not perform this step, even if awe is enabled, SQL Server can only use 2 GB of memory.
reference: SQL Server only uses 2 GB of memory even though the awe option is enabled
4. for SQL Server 2000 SP4, install the following patch. Otherwise, you can only use up to 50% of the physical memory.
reference: fix: some memory is unavailable when awe is enabled on a 32-bit SQL Server 2000 SP4 computer
patch: fix: not all memory is available when awe is enabled on a computer running 32-bit version of SQL Server 2000 SP4 (899761)

5. Restart the machine.

Note: After awe is enabled, the actual memory allocated by the SQL server instance cannot be seen in the task manager. In the performance monitor, use the total server memory (Kb) of the SQL Server: memory manager object) the counter determines the memory size allocated by the SQL server instance running in awe mode.

If a blue screen or unresponsive problem occurs after you enable PAE and awe, refer: you may notice unpredictable behavior on a Multiprocessor computer that is running SQL Server 2000 and has the physical addressing extensions (PAE) specification enabled