David,
This is a neat way of capturing that information:
select name,
value,
value_in_use
from sys.configurations
where name in
(
N'min server memory (MB)',
N'max server memory (MB)',
N'awe enabled'
);
Looks like 32-bit SQL Server running under WOW64 to me.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi