• select @@SERVERNAME as "Server_Name" , value from master.sys.configurations where name = 'max server memory (MB)'