Post reply

SQL SERVER 2014 Memory values

  • January 18, 2017 at 11:57 am

    #317783

    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

  • January 18, 2017 at 2:48 pm

    #1923555

    ganci.mark - Wednesday, January 18, 2017 11:57 AM

    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

    I figured out why the VAS is 128TB as opposed to 8TB. As the newer OS's are released they are able to work with the larger amounts of  virtual memory addressing. Server 2012 has reached 128TB.
    I originally thought 8TB was the max in a x64 bit system, but it is much more than that.  The operating systems VAS increases in size as new versions are released.
    -Mark G

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply