Summary
This chapter focused on the memory configuration settings that a DBA will need to understand and may need to adjust. SQL Server 2005 performs dynamic memory allocation and deallocation by default in all cases but one—when it is run on 32-bit Windows 2000 with AWE enabled. The configuration options may be manually set to adjust dynamic memory allocation minimum and maximum limits or to configure a static memory size for SQL Server. Using these settings appropriately is very important to SQL Server performance.
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.
