Are you use x64 OS and x64 of SQL 2005?

-----Original Message-----
From: Horn Matt
[mailto:mssqldba-ezmlmshield-x33399750.[Email address protected]
Sent: Friday, March 30, 2007 7:14 AM
To: LazyDBA Discussion
Subject: Max Memory in SQL 2005

All,

What is the absolute maximum memory that SQL 2005 can see?

I have a 2003 Enterprise server with 32 gig of memory, but when I go to
edit the memory settings on the SQL instance, it only shows a maximum of
21 gig, even using AWE

Is that the max? Or do I need some sort of switch..


Thanks,
Matt

CONFIDENTIALITY NOTICE: This E-Mail is intended only for the use of the
individual or entity to which it is addressed and may contain
information that is privileged, confidential and exempt from disclosure
under applicable law. If you have received this communication in error,
please do not distribute and delete the original message. Please notify
the sender by E-Mail at the address shown. Thank you for your
compliance.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.


MS Sql Server LazyDBA home page