Warren Peace (8/6/2009)
First, AWE is not an option on x64 hardware because it is not needed. You don't have to check the box to enable it - it is not recognized on x64 systems.
Yes, there is an option build a Win x64 server with SQL x64. It's even available in SQL 2008 x64. Heres the setting of a win2008 x64 with SQL x64:
http://207.231.94.134/x64AWE.jpg
If it's there and selectable, one has to ask the question why is it even there if you say it's not. Do you know something we dont? If so let us know.
Well, it's there, but not used/taken in consideration. read here it specifically states:
Support for AWE is available only in the SQL Server 2005 Enterprise, Standard, and Developer editions and only applies to 32-bit operating systems
and
Note that the sp_configure awe enabled option is present on 64-bit SQL Server, but it is ignored. It is subject to removal in future releases or service packs of 64-bit SQL Server.
I know... there's a lot of confusion on this topic... 🙂
