SQL Server Memory Allocation

Memory management in SQL Server 2005 requires little or no user intervention, and by default memory is allocated and deallocated dynamically by SQL Server as needed for optimal performance, according to the amount of physical memory available. You can override this dynamic behavior if necessary using the configuration options described in this section.

Dynamic Memory Allocation

With SQL Server 2005, memory allocation is by default dynamic, even when AWE is enabled. (AWE is applicable only on 32-bit operating systems and is explained in detail in Chapter 5.) The exception to this is when running SQL Server 2005 on Windows 2000 32-bit operating system with AWE enabled. In this case, the memory allocation is not dynamic ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.