Is Lock Pages In Memory enabled If lock pages in memory is enabled you can see the “Using locked pages for buffer pool” is recorded in the SQL Server error log. exec xp_readerrorlog 0, 1, 'locked pages'