SQL Server only uses 2 GB of memory even though the AWE option is enabled (811891)
The information in this article applies to:
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft Windows 2000 Advanced Server
- Microsoft SQL Server 2005 Enterprise Edition
SYMPTOMS SQL Server only uses 2 gigabytes (GB) of memory even though
SQL Server is configured to use the Microsoft Windows 2000 Address Windowing
Extensions (AWE) API to support a maximum of 64 GB of physical memory when the awe enabled option is set to 1. Windows Task Manager also shows that SQL
Server is using only 2 GB of memory.
In the SQL Server log, you will
see the following message:
Cannot use Address
Windowing Extensions because lock memory privilege was not
granted.CAUSEThe user account the SQL Server service is running on was
not added to the Lock Page in Memory policy of the User Rights Assignments in the
Local Security Policy of the computer.RESOLUTIONTo resolve this problem, follow these steps: Note: You can only perform these tasks at the individual server
console. To perform these tasks, you must log on to Windows as a local
administrator on the computer where SQL Server exists. - On the Taskbar, click Start, and then
click Programs.
- Click Administrative Tools, and then
select Local Security Policy.
- Expand Security Settings, expand
Local Policies, and then click User Rights
Assignments.
- In the right screen, right-click Lock pages in
memory, and then click Security.
- In the Local Security Policy Setting
dialog box, click Add.
- Click to select the account where the MSSQLSERVER service
is running.
- Click OK.
- For Microsoft Windows 2000 Server, in the command window, type Secedit /refreshpolicy machine_policy /enforce. For Microsoft Windows Server 2003, in the command window, type GPUPDATE /force.
- Restart the SQL Server service.
REFERENCES
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
329914
AWE-enabled SQL Server 2000 may take a long time to start
298444 A description of the Group Policy Update utility
Modification Type: | Major | Last Reviewed: | 4/12/2006 |
---|
Keywords: | kbSysAdmin kbSecurity kbprb KB811891 kbAudDeveloper |
---|
|