O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required