Check if your SQL Server is under Memory Pressure

-- SQL Server Process Address space info

--(shows whether locked pages is enabled, among other things)

SELECT physical_memory_in_use_kb/1024000 Physical_MM_in_use_GB,locked_page_allocations_kb/1024000 Locked_Pages_Allocated_GB,

page_fault_count, memory_utilization_percentage,

available_commit_limit_kb/1024000 Available_Commit_Limit_GB, process_physical_memory_low,

process_virtual_memory_low

FROM sys.dm_os_process_memory WITH (NOLOCK) OPTION (RECOMPILE);

-- You want to see 0 for process_physical_memory_low

-- You want to see 0 for process_virtual_memory_low

-- This indicates that you are not under internal memory pressure