Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

AWE is not enabled on our SQL Server 2005 which is 32-bit, but operating system is 64-bit.

Can/should we enable AWE bcos SQL/OS both on different bit type.

Regards

share|improve this question

migrated from stackoverflow.com Nov 20 '11 at 1:07

This question came from our site for professional and enthusiast programmers.

If you want to allocate more than 4GB of RAM to your SQL Server instance then yes, you should enable AWE.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.