AWE on 64-bit plateform

[bob123]

Hi,

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

Thanks

[Tom Cooper]

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" <bob...@gmail.com> wrote in message
news:4c500b56$0$674$426a...@news.free.fr...

[Erland Sommarskog]

bob123 (bob...@gmail.com) writes:
> Is AWE useful with SS 64-bit on
> a 64-bit platform ?

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, esq...@sommarskog.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/prodinfo/previousversions/books.mspx