How to check Lock Pages In Memory is enabled?


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' 

5 thoughts on “How to check Lock Pages In Memory is enabled?

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

  2. Sarabjeet Singh's avatarSarabjeet Singh

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

    Reply

Leave a reply to Sarabjeet Singh Cancel reply