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'

Leave a Reply

Your email address will not be published. Required fields are marked *