Memory Model

Having the SQL Server memory model set to "Lock Pages" means that the OS cannot trim or page any memory being used by SQL Server until it's explicitly released.

Suggested Action

Consider enabling lock pages in memory.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.