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'
Pingback: Lock Pages in Memory enabled but “Using locked pages for buffer pool” message not found « Ramblings of a SQL DBA mind…
How to disable the feature “Lock Pages In Memory”.
go to local security policy and remove SQL Server service account and sql server will not use it.
I need to enable LPIM settings to multiple servers(1000+). Can you please help me to get some script?
You can try it using powershell script.