What is lock page memory

• rajeshjaiswalraj

  SSCrazy

  Points: 2574

  More actions

  June 2, 2015 at 12:34 am

  #317886

  What is lock page memory. How it will work and why it will increase the performance.

  Then what is the difference between setting the - max/Min server memory and Lock page memory

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  June 2, 2015 at 1:05 am

  #1802225

  A quick Bing search will help you??

  MAX / MIN settings - https://technet.microsoft.com/en-us/library/ms180797(v=sql.105).aspx"> https://technet.microsoft.com/en-us/library/ms180797(v=sql.105).aspx

  LPIM (Article is 2008 based but still is a good read )

  https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/"> https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/