Check server Lock Pages in Memory (aka “LPIM”) setting

Problem

Check if the server is using Lock Pages in Memory registry settings

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_check_server_lock_pages_in_memory.sql

Example