Memory Model is CONVENTIONAL

Altering the SQL Server memory model to LOCK_PAGES means that the OS cannot trim or page any memory being used by SQL Server until it's explicitly released.


If you're using SQL Server Enterprise Edition and have more than 8GB of physical RAM, then you could consider LARGE_PAGES as described in SQL Server and Large Pages Explained by Bob Ward (Microsoft).

Suggested Action

Consider enabling lock pages in memory.

How To Check SQL Server Memory Model

SELECT sql_memory_model_desc FROM sys.dm_os_sys_info;

Further Reading

Enable the Lock Pages in Memory Option (Windows) | Microsoft Docs

sys.dm_os_sys_info (Transact-SQL) | Microsoft Docs

SQL Server and Large Pages Explained…. | Microsoft Docs