I ran the following query while investigating some memory issues.
select (physical_memory_in_use_kb/1024)Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024 )Locked_pages_used_Sqlserver_MB, (total_virtual_address_space_kb/1024 )Total_VAS_in_MB,
process_physical_memory_low, process_virtual_memory_low from sys.dm_os_process_memory
229127 0 134217727 0 0
Notice the value for Total_VAS_in_MB is well over 8TB.
This is a 64 Bit server 2012 and SQL Server 2014 Enterprise SP 2 x64. Shouldn't this value be 8TB?
I have max server mem set to 160GB. I am trying to figure out what is using the extra 70GB right now.
Does anyone know why my VAS would be over 130TB?
Thanks
Mark