Limitations of using AWE Memory in SQL Server

 Posted by PandianS on 12/11/2010 | Category: Sql Server Interview questions | Views: 5580 | Points: 40
Answer:

1. SQL Server uses AWE(Address Windowing Memory) to use Physical Memory over 4GB on 32 bit Operating system.
2. AWE option supported in SQL Server Enterprise, Standard & Developer editions only.
3. AWE option allowed only in 32 bit operating system.
4. But this option is available in 64 bit operating system also, But its ignored, In futured version of service pack, The option will be removed.
5. SSAS (Analysis Services) can not take advantage of AWE memory.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response