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 |