This section describes the architecture of Microsoft SQL Server memory algorithms. It makes recommendations for exploiting the new enhancements in memory, including: dynamic memory configuration, stored procedures, log, and other configuration settings.
The memory algorithms and use of memory by SQL Server objects are major changes in SQL Server 7.0 that improve the performance of the database and also minimize the work the database administrator must do to configure memory for good performance.