How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?
Try this on the master database:
SELECT name, value, value_in_use, [description]
FROM sys.configurations
WHERE name like '%server memory%'
ORDER BY name OPTION (RECOMPILE);
Gives you max server memory (MB) and min server memory (MB)