Tente isso no banco de dados master
:
SELECT name, value, value_in_use, [description]
FROM sys.configurations
WHERE name like '%server memory%'
ORDER BY name OPTION (RECOMPILE);
Fornece max server memory (MB)
e min server memory (MB)