How to check Lock Pages In Memory is enabled?

Written by

Jugal Shah

in

, , , , , ,

You can use below simple technique to check whether lock pages in memory is enabled or not. If lock pages in memory is enabled you can see the “Using locked pages for buffer pool” message in the SQL Server error log.

exec xp_readerrorlog 0, 1, 'locked pages'

To check if it is disabled. You have to check for the “Address Windowing Extensions (AWE) requires the ‘lock pages in memory’ privilege which is not currently present in the access token of the process.” message.

exec xp_readerrorlog 0, 1, 'lock pages in memory'

Comments

5 responses to “How to check Lock Pages In Memory is enabled?”

  1. Lock Pages in Memory enabled but “Using locked pages for buffer pool” message not found « Ramblings of a SQL DBA mind…

    […] http://sqldbpool.com/2012/08/28/how-to-check-lock-pages-in-memory-is-enabled/ […]

    Reply
  2. srinu6k Avatar
    srinu6k

    How to disable the feature “Lock Pages In Memory”.

    Reply
    1. Jugal Shah Avatar
      Jugal Shah

      go to local security policy and remove SQL Server service account and sql server will not use it.

      Reply
  3. Sarabjeet Singh Avatar
    Sarabjeet Singh

    I need to enable LPIM settings to multiple servers(1000+). Can you please help me to get some script?

    Reply
    1. Jugal Shah Avatar
      Jugal Shah

      You can try it using powershell script.

      Reply

Thanks for the comment, will get back to you soon… Jugal Shah

More posts