Can AWE be enabled on a 64 bit

Question

Post reply

Can AWE be enabled on a 64 bit

smilewithrams-907484

Valued Member

Points: 63
More actions
January 26, 2009 at 10:54 pm

#199244

Hi all,
Can anyone explains me whether AWE can be enabled on a 64 Bit. if so plz specify the reason

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Simple answer, no. It isn't needed on the 64-bit OS as it handles memory differently than the 32-bit OS.

465789psw Hall of Fame Points: 3314 More actions · Answer 2

please see Slava's post....Microsoft does recommend it be turned on! this only goes for enterprise addition.

http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

others that will help

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx

see this post for standard edition

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx

good luck!

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

I'll have to check those out from home. Unfortunately most blog sites get blocked here at work.

DHeath SSCertifiable Points: 5200 More actions · Answer 4

So my question is this..if you have 64Bit MSSQL Ent Edition why would you need AWE if you are running with 64Bit Ent Edition OS. Considering that the Entprise Edition of SQL will see everything (memory wise)the OS is capable of seeing. Please correct me in my misunderstandings ...

Thanks

Darryl

DHeath

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

DHeath (1/27/2009)
So my question is this..if you have 64Bit MSSQL Ent Edition why would you need AWE if you are running with 64Bit Ent Edition OS. Considering that the Entprise Edition of SQL will see everything (memory wise)the OS is capable of seeing. Please correct me in my misunderstandings ...
Thanks
Darryl

Excellent question, and I agree. That's one of the reasons I am going to try and read those blog posts when I get home and see what the say.

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 6

from http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx#EUVAE:

On both 32- and 64-bit platforms, memory that is allocated through the AWE mechanism cannot be paged out. This can be beneficial to the application. (This is one of the reasons for using AWE mechanism on 64-bit platform.)

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]