Can you technically explain how memory allocated and lock pages works?

[Haris]

Hi, I have a problem with you, can you technically explain how memory allocated and lock pages works? Please, please give me a hand as soon as possible.

[Curtis]

There are a couple of memory settings within SQL that can be configured – Max and Min Server Memory.  When configuring the Max Memory setting (and Min Memory setting) for SQL Server, it is important to realize that these settings only affects the SQL Buffer Pool.