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

đź’ˇ Select 'Suggested Script' for an automatically generated script.

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