in

SQL Server Blogs

Voices from the UK SQL Server Community

Rob's SQL Server Blog

... SQL Server thoughts from the field

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 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

Comments

 

GrumpyOldDBA said:

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

May 16, 2008 8:48 AM
 

SQL Server and Windows Memory said:

Pingback from  SQL Server and Windows Memory

May 17, 2008 5:21 AM
Powered by Community Server (Commercial Edition), by Telligent Systems