The way that an application manages critical resources such as memory tells us a lot about how it is designed. It tells us what priority the application designers placed on efficient resource utilization and on maximizing the performance of the application.
This chapter from the book The Guru's Guide to SQL Server Architecture and Internals, by Ken Henderson, explores SQL Server's memory management architecture. It examines the importance the designers of SQL Server placed on efficient memory management and maximum system performance. SQL Server attempts to strike a balance between getting the most out of the resources available to it and running well alongside other applications on the system.
Click here for more information on Addison-Wesley Professional, the author, or to buy the book.
This was first published in July 2005