Some memory is unavailable when awe is enabled on a 32-bit SQL Server 2000 SP4 computer.

Update information:Microsoft found a problem in the final internal version of SP4. If you enable the awe Support feature when running SQL Server, it will be affected. This issue has no impact on the IA64 platform. On x86 and x64 systems, this issue affects only users who have enabled awe and occupied more than 2 GB of memory (applicable only to Enterprise, developer, and evaluation versions ); more than half of the system's total memory is allocated to a single SQL server instance.Users with this configuration should obtain and apply the patches specified in Article 899761 of the Microsoft Knowledge Base after upgrading to SP4.Program.

The following is Article 899761 in the Microsoft Knowledge Base:

Symptom

If address processing wing Extentions (AWE) is enabled, a single SQL Server 2000 instance can only use up to 50% of the physical memory on the computer.

Note:: This issue occurs only in Microsoft SQL Server 2000 Service Pack 4, which runs on x86 or x64-based computers.

For example, if your computer has 16 gb ram and awe is enabled, a single instance of SQL Server 2000 can only access 8 GB RAM.

To determine whether awe is enabled, run the following script from the SQL query Analyzer:

 
Sp_configure 'show advanced options', 1goreconfiguregosp_configure 'awe enabled' go
 

IfRun_valueIf this parameter is set to 1, awe is enabled on the server.

To view this phenomenon, check the "SQL SERVER: Memory Manager/total server memory (Kb)" counter in the system monitor. On a computer running SQL Server Service Pack 3 (SP3), this value can be the maximum amount of physical memory on the computer. On a computer running SQL Server SP4, this value will never exceed 50% of the physical memory.

Note:

•	This problem only occurs on a computer with more than 2 gb ram.
•	If awe memory is usedMax Server MemoryIf the value of the option is set to 50% lower than the physical memory, it will not be affected.
•	Awe is not available in all versions of SQL Server 2000. For example, awe is unavailable for MSDE, SQL Server 2000 Standard Edition, SQL Server 2000 Personal Edition, or installation that only contains SQL Server 2000 tools.
•	If you run SQL Server 2000 SP4 on a IA-64-bit system, this issue is not affected.

Cause

This problem occurs because the total number of available buffer pages is based on the comparison of the number of SQL pages (8 KB) and system pages (4 kb, the comparison result is incorrect. On the IA-64 BIT system, because this comparison is not performedCodeTherefore, this problem does not occur. Solution

Fix program information

To obtain this fix, visit the following Microsoft Website:

Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 7c407047-3f1f-48b8-9e4c-dc32875e1961 (Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 7c407047-3f1f-48b8-9e4c-dc32875e1961)

Important: Only one download exists for x64 and x86-based computers. This fix uses the installer technology that will determine the platform and install the correct files.

Prerequisites

SQL Server 2000 Service Pack 4.

To obtain SQL Server 2000 Service Pack 4, visit the following Microsoft Website:

Http://www.microsoft.com/technet/prodtechnol/ SQL /2000/downloads/default.mspx Http://www.microsoft.com/technet/prodtechnol/ SQL /2000/downloads/default.mspx) Restart Information

You do not have to restart your computer after applying this fix.

Registry Information

You do not have to change the registry.

Fix program file information

This fix contains only the files necessary to resolve the issues listed in this article. This fix does not include all files necessary to completely update the product to the latest version.

The English version of this hotfix has the file attributes listed in the following table (or updated file attributes ). The dates and times of these files are listed in Coordinated Universal Time (UTC. When you view the file information, the time is converted to the local time. To learn about the time difference between UTC and local time, use the time zone tab in the date and time tool in the control panel.

SQL Server 2000 32-bit edition based on x86 computers

 
Date and Time version size file name --------------------------------------------------------- 14-may-2005 011 2000.80.2040.0 9,150,464 sqlservr.exe
 

Applicable to 64-bit SQL Server 2000

Date and Time version size file name platform ------------------------------------------------------------------- 14-may-2005 011 2000.80.2040.0 9,150,464 sqlservr.exe x86
 

Note:: Due to file relevance, the latest fixes or features that contain these files may include other files. More information

For more information about awe, clickArticleTo view the articles in the Microsoft Knowledge Base:

274750 Http://support.microsoft.com/kb/274750) How to configure more than 2 GB memory in SQL Server

For more information about the naming mode updated by Microsoft SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:

822499 Http://support.microsoft.com/kb/822499) New naming mode for Microsoft SQL Server Software Update packages

For more information about Microsoft correcting the terms used by the software after the software is released, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Http://support.microsoft.com/kb/824684) My notes for describing Microsoft software update standard terms: that is, if the SQL Server SP4 patch win2003 (Enterprise Edition, up to 4 GB memory can be identified) is applied ), servers with more than 4 GB physical memory. If the PAE switch is added to boot. ini, the system recognizes memory above 4 GB. The awe switch of SQL Server is also enabled, and the SQL Server recognizes memory above 4 GB. However, if this Patch Is Not Installed, SQL Server can only use up to half of the physical memory.