Solved

AWE and 64 bit SQL

Posted on 2010-08-12
4
498 Views
Last Modified: 2012-05-10
Does 64 bit SQL require AWE setting for the buffer to reach all of the memory range?

Thanks
0
Comment
Question by:anushahanna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 250 total points
ID: 33422770
No.
In fact:
http://msdn.microsoft.com/en-us/library/ms190673.aspx
"AWE is not required and cannot be configured on 64-bit operating systems."
0
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 250 total points
ID: 33422783
according to http://msdn.microsoft.com/en-us/library/ms190673.aspx
AWE is not required and cannot be configured on 64-bit operating system
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33422787
OK. thanks very much for that info.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 33422875
Hold on here...AWE IS used...but it does it regardless of if you set it or not.  The reason?  SQL wants to use extra memory so that it can lock these pages in memory.
0

Featured Post

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

696 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