Get installed physical memory with PowerShell

## get the installed physical memory with below PowerShell query

(Get-WMIObject -class Win32_PhysicalMemory -ComputerName $COMPUTERNAME|
Measure-Object -Property capacity -Sum).Sum/1GB

How to get OS Physical memory and max server memory value using TSQL

—-For 2012 earlier versions
Select
physical_memory_in_bytes/1048576 as physical_memory_mb
from sys.dm_os_sys_info

— For 2012 and later versions
Select
physical_memory_kb /1024 as physical_memory_mb
from sys.dm_os_sys_info

—For Max server memory value
SELECT name, value, value_in_use, [description]
FROM sys.configurations
WHERE name like ‘%max server memory%’