SQL Server不使用可用内存

我们正在Windows 2016标准版上使用SQL Server 2008 R2

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)   
Aug 19 2014 12:21:34   
Copyright (c) Microsoft Corporation  
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) 

该计算机具有128GB的RAM,但是SQL Server仅使用4GB。

SELECT 
    physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB, 
    large_page_allocations_kb/1024 AS sql_large_page_allocations_MB, 
    locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB,
    virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB, 
    virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB, 
    virtual_address_space_available_kb/1024 AS sql_VAS_available_MB,
    page_fault_count AS sql_page_fault_count,
    memory_utilization_percentage AS sql_memory_utilization_percentage, 
    process_physical_memory_low AS sql_process_physical_memory_low, 
    process_virtual_memory_low AS sql_process_virtual_memory_low
FROM 
    sys.dm_os_process_memory; 

退货

enter image description here