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).
💡 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;
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