AWE for 32 bit SQL Server on windows 64 bit ?

Leave a comment (0) Go to comments

Do I need to enable AWE in 32 bit SQL Server (for using more than 4 GB) on windows 64 bit ?

NO, there is no way to where we can use use more then 4GB of memory for a 32bit SQL-Server on a 64bit windows OS.

I understand, that we can enable the AWE switch to make the SQL-Server use more then 4GB, but this doesn’t work on a 64bit OS

This sound harsh, but here are facts,

  1. Support for AWE is available only in the SQL Server 2005 Enterprise, Standard, and Developer editions and only applies to 32-bit operating systems
  2. AWE is not supported on 64-bit machines
  3. 232 = 4 GB
  4. 32-bit applications on 64-bit platforms can address up to 2 GB, or up to 4 GB with the /LARGEADDRESSAWARE:YES linker flag.

If you need to make SQL Server to use more than 4GB of memory, switch to 64-bit version of SQL Server.

For More Details on Running SQL Server 32 bit on windows 64 bit, check my other post.

EOF - AWE for 32 bit SQL Server on windows 64 bit ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.