AWE is currently enabled on a 32-bit instance of SQL Server.

Asked By 0 points N/A Posted on -
qa-featured

Hi Team,

When I enable AWE and run it then this error occurred then AWE checks failed and the following error occurs.

Can anyone tell how I may be able to upgrade to SQL Server 2012 with Lock Pages in Memory.

Thanks in advance.

Rule check result

Rule “Is AWE Enabled Check for x86 installations” failed.

AWE is currently enabled on a 32-bit instance of SQL Server. This feature is no longer supported. You must disable AWE before upgrading the instance.

SHARE
Best Answer by ZimriAcke
Answered By 0 points N/A #138122

AWE is currently enabled on a 32-bit instance of SQL Server.

qa-featured

Hi,

   The AWE is enabled in 32 bit.You want to check weather the physical memory exists in your system or not.Therefore an application requires an lock pages in memory.

In case of 32-bit is not an problem to upgrade an SQL server 2012.Just you enable "LOCKED PAGES"feature and install it.

 

Best Answer
Best Answer
Answered By 0 points N/A #138123

AWE is currently enabled on a 32-bit instance of SQL Server.

qa-featured

Hi Jane,

In a 64 bit version of SQL Server all the memory on the server can be directed without having to use AWE. Try to observe when lock pages in memory is enabled and the results in the use of AWE. When the locked pages in memory privilege is set, SQL Server uses the Windows AWE API to do memory allocations as it's a little bit faster. So enablign it does nothing.

Hope it helps.

Login/Register to Answer

Related Questions