-- memory overview
SELECT  CAST(physical_memory_in_bytes / (1024.0 * 1024.0 * 1024.0) AS DECIMAL(20, 2)) AS PhysicalMemoryGB,
        CAST(virtual_memory_in_bytes / (1024.0 * 1024 * 1024) AS DECIMAL(20, 2)) AS VasGB,
        CAST((bpool_committed * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolCommittedMemoryGB,
        CAST((bpool_commit_target * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolTargetMemoryGB,
        (
         SELECT CAST(CAST(value_in_use AS INT) / 1024.0 AS DECIMAL(20, 2))
         FROM   sys.configurations
         WHERE  name = 'min server memory (MB)'
        ) AS MinServerMemoryGB,
        (
         SELECT CAST(CAST(value_in_use AS INT) / 1024.0 AS DECIMAL(20, 2))
         FROM   sys.configurations
         WHERE  name = 'max server memory (MB)'
        ) AS MaxServerMemoryGB,
        (
         SELECT value_in_use
         FROM   sys.configurations
         WHERE  name = 'awe enabled'
        ) AS IsAweEnabled
FROM    sys.dm_os_sys_info;