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

Asked By Jane Jimenez 0 points N/A Posted on - 12/03/2012

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.

• Status: Open
• Question Views: 959
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Software Others

Best Answer by ZimriAcke

Go To Solution

Answered By sharmiv 0 points N/A #138122

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

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.

 

About sharmiv

Questions
0

Answers
13

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/13/2012
• Question Category: Software Others

Best Answer

Best Answer

Answered By ZimriAcke 0 points N/A #138123

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

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.

About ZimriAcke

Questions
0

Answers
25

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 12/23/2012
• Question Category: Software Others