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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.