SQL Server and Windows Memory

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve memory not in use by other applications and the OS. Each instance must statically allocate…

2

Windows Memory (PAE/AWE/3GB)

PAE (Physical Address Extension) PAE is the added ability of the IA32 processor to address more than 4GB of physical memory. The following OS’s can use PAE to take advantage of physical memory beyond 4GB: Microsoft Windows 2000 Advanced Server Microsoft Windows 2000 Datacentre Server Microsoft Windows Server 2003 Enterprise Edition Microsoft Windows Server 2003 Datacentre Edition To enable PAE,…

1