SQLServerPedia

Paul Randal wrote about couple of neat tricks to identify if Lock pages in memory is enabled for the SQL Service account. Here is another to check if SQL Server is using ‘Lock pages in memory’ and of course this is only Enterprise edition feature in both SQL 2K5/8.

exec xp_readerrorlog 0, 1, 'locked pages' 

and the result would look something like below.

LogDate                    ProcessInfo    Text
2009-04-13 00:31:07.840    Server         Using locked pages for buffer pool.