-- 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;

-- cpu overview
SELECT  osi.cpu_count AS LogicalCpuCount,
        osi.hyperthread_ratio AS HyperthreadCoreRatio,
        osi.cpu_count / osi.hyperthread_ratio AS PhysicalCpuCount,
        (
         SELECT COUNT(*)
         FROM   sys.dm_os_schedulers
         WHERE  scheduler_id < osi.cpu_count
                AND is_online = 1
        ) AS LogicalCpuOnline
FROM    sys.dm_os_sys_info osi;