SQL Server and Windows Memory

Published 15 May 08 03:02 PM | robcarrol
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 the memory it needs. AWE memory can only be used for the data cache and not for executables, drivers, DLL's, etc.

Cross Posted from blogs.technet.com/rob

Filed under: , ,

Comments

# GrumpyOldDBA said on May 16, 2008 08:48 AM:

If you upgrade to w2k3 you can use 64gb of ram without datacentre - does anyone actually still use windows 2000 ?

# SQL Server and Windows Memory said on May 17, 2008 05:21 AM:

Pingback from  SQL Server and Windows Memory