AWE has removed from SQL server 2012 AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit servers. To use more than 4GB memory you have to buy 64 bit servers. A small organization may suffer because of this feature has removed from the next version. For more look the following links SQLOS Team’s post : SQL Server Memory Manager Changes in Denali http://sqlblog.com/blogs/sqlos_team/archive/2011/01/04/sql-server-memory-manager-changes-in-denali.aspx MS’s post : Features Not Supported in the Next Version of SQL Server http://msdn.microsoft.com/en-us/library/ms143729.aspx