Enable "lock Memory Page" for awe"

Source: Internet
Author: User

This policy determines which accounts can use processes to keep data in the physical memory, thus preventing the system from paging data to the virtual memory of the disk. In SQL Server 2005, the "Lock Memory Page" option is set to off by default. If you have System Administrator privileges, you can use the Windows Group policy tool (gpedit. MSC) to manually enable this option and assign this permission to the account that is running SQL Server.

For more information about how to enable the "Lock Memory Page" option, see how to enable the "Lock Pages In Memory" option (Windows ).

Although there are no requirements, we recommend that you Lock pages in the memory when using a 64-bit operating system. For 32-bit operating systems, you must grant the "Lock Memory Page" permission before configuring awe for SQL Server.

How to enable the "Lock Memory Page" option (Windows)

By default, the Windows Policy "locking the memory page" is disabled". You must enable this permission to configure the address window extension (AWE ). This policy determines which accounts can use processes to keep data in the physical memory, thus preventing the system from paging data to the virtual memory of the disk. In a 32-bit operating system, setting this permission without awe significantly reduces system performance. You do not need to lock pages in the memory on a 64-bit operating system.

Use the Windows Group policy tool (gpedit. MSC) to enable this policy for the account used by SQL Server. You must be a system administrator to change this policy.

For tables that list the maximum Server Memory values, see memory architecture.

Enable the "Lock Pages In Memory" option

  1. In"Start"Click"Run". In"Open"Box, type
    Gpedit. MSC
    .

    Will open"Group Policy"Dialog box.

  2. In"Group Policy"Console, expand"Computer Configuration", And then expand"Windows Settings".

  3. Expand"Security Settings", And then expand"Local Policy".

  4. Select"User Rights Assignment"Folder.

    The details pane displays the policy.

  5. In this pane, double-click"Locking pages in memory".

  6. In"Local Security Policy Settings"In the dialog box, click"Add"Button.

  7. In"Select user or group"In the dialog box, add an account that has the permission to run sqlservr.exe.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.