Q and A: Enabling AWE settings for SQL Server 32 bit edition in WOW

Q.  A customer wants to run SQL 2000 SP4 in a Windows Server 2003 SP1 x64 edition. They did the installation without problems but SQL Server is not using more than 4GB of memory.  Is it possible to enable AWE in this configuration?

A.  The answer is yes, you should follow exactly the same procedure as you would when running SQL Server 32 bit version on 32 bit OS. See http://msdn2.microsoft.com/en-us/library/ms175581(SQL.90).aspx for more information. In addition keep in mind that maximum amount of physical memory SQL Server will use in this configuration is limited to 64GB. See http://blogs.msdn.com/slavao/archive/2005/06/03/424825.aspx for more information.

Skip to main content