sys.dm_os_sys_info

Description

Analytics Platform System (PDW) Returns a miscellaneous set of useful information about the computer, and about the resources available to and consumed by SQL Server. Specifies the current CPU check count. CPU ticks are obtained from the processor’s RDTSC counter. It’s a monotonically increasing number. Not nullable. Specifies the number of milliseconds since the computer started. Not nullable. Specifies the number of logical CPUs on the system.

Syntax

physical_memory_in_bytes