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.

LARGE_PAGES

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

💡 Aireforge Advisor can automatically generate a script for this.

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