Hi,

Is AWE useful with SS 64-bit on
a 64-bit platform ?

Thanks

No. See http://msdn.microsoft.com/en-us/library/ms190673.aspx
which states "AWE is not required and cannot be configured on 64-bit
operating systems.".

Tom

"bob123" <bob123 (AT) gmail (DOT) com> wrote

bob123 (bob123 (AT) gmail (DOT) com) writes:
As Tom says, no.

Note however, that to use AWE on 32-bit systems, the service account for SQL
Server needs to have the permissions "Lock pages in memory". And this
permission is very useful on 64-bit as well, since it prevents from SQL
Server from being swapped out if a bad driver starts to steal memory in
the machine. To take benefit of this protection in Standard Edition, you
need one of the more recent CU:s.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx