Paul White NZ (8/13/2010)
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
Definitely like the view. Thanks!
Out of curiosity what makes you think this is a WOW configuration even though he stated that both Windows and SQL Server were 64-Bit?
As long as you are willing to share info, I'll take it in. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot