Solved

AWE extension

Posted on 2014-12-09
4
73 Views
Last Modified: 2014-12-24
Hi experts:

i am reading about:
AWE extension can no longer be used to access additional memory on 32bit systems

but i do not understand this:
Could be a significant issue for 32 bit upgrades to SQL Server 2012
0
Comment
Question by:enrique_aeo
  • 2
4 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 150 total points
Comment Utility
32 bit SQL server running on a 64 bit os  without AWE can access a max memory of 4GB,  for anything beyond this you need AWE. So if you are upgrading to 32 bit sql 2014 ( on a 64bit os ) the maximum memory it can access will be 4GB.  otherwise you should upgrade to 64bit SQL
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
It depends on which version of Operating System and SQL Server are you using.
0
 

Author Comment

by:enrique_aeo
Comment Utility
Vitor Montalvão: more detail please
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 350 total points
Comment Utility
AWE extension can no longer be used to access additional memory on 32bit systems
That's true since MSSQL 2012, so if you still working with previous SQL Server's versions you can still use AWE.
If you have a SQL Server 2008R2 32bits or any previous 32bits version of SQL Server you can only set the AWE if the Windows Server is also 32bits. Don't works on 64bits of Windows Server.

And that's why it told "It depends on which version of Operating System and SQL Server are you using. "
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now