Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

AWE and 64 bit SQL

Does 64 bit SQL require AWE setting for the buffer to reach all of the memory range?

Thanks
0
anushahanna
Asked:
anushahanna
2 Solutions
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
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
 
James MurrellProduct SpecialistCommented:
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
 
anushahannaAuthor Commented:
OK. thanks very much for that info.
0
 
chapmandewCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now