Post reply

set Lock Pages Memory Option under the Local Security

  • January 7, 2010 at 6:46 am

    #156562

    My SQL is the Standard Edition. and SQL is running under the Local Service Account that account by default had the Lock Pages option enabled (even though the Local Security Policy may not reflect that).

    Can someone confirme why SQL generates the message that AWE cannot be enabled due to not having the Lock Pages enabled for the user.

    I thought to set Lock Pages Memory Option will improve performance. Any suggestions??? Why would it makes a big difference in how AWE is handled/supported?

    Thank you

  • January 7, 2010 at 7:15 am

    #1100183

    My SQL is the Standard Edition. and SQL is running under the Local Service Account that account by default had the Lock Pages option enabled (even though the Local Security Policy may not reflect that).

    Can someone confirme why SQL generates the message that AWE cannot be enabled due to not having the Lock Pages enabled for the user.

    I thought to set Lock Pages Memory Option will improve performance. Any suggestions??? Why would it makes a big difference in how AWE is handled/supported?

    Thank you

    hi,

    This Lock Pages Memory policy determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk.

    so try to start sql server with any specific user id and enable awe

    Regards,
    Shivrudra W

  • January 7, 2010 at 7:23 am

    #1100195

    Krasavita (1/7/2010)

    My SQL is the Standard Edition. and SQL is running under the Local Service Account that account by default had the Lock Pages option enabled (even though the Local Security Policy may not reflect that).

    Can someone confirme why SQL generates the message that AWE cannot be enabled due to not having the Lock Pages enabled for the user.

    I thought to set Lock Pages Memory Option will improve performance. Any suggestions??? Why would it makes a big difference in how AWE is handled/supported?

    Thank you

    First by default Lock Pages in Memory option is disabled .

    Can u post the full sql server version using @@verion

    How much memory the server has

    What's error message r u getting ?

    http://www.sqlservercentral.com/articles/Administration/aweadventures/960/

    Edit:For add the url

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply