Slava Oks's WebLog

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.

Published Wednesday, April 12, 2006 2:25 PM by slavao

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required
Submit

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker