SDU Tools 140 Determine if Lock Pages in Memory is enabled on SQL Server using T SQL
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. IsLockPagesInMemoryEnabled is a simple function that works of if the Lock Pages in Memory setting is currently enabled.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com