Manage Learn to apply best practices and optimize your operations.

SQL Server memory management

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.

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 to download this free book chapter.

Click here for more information on Addison-Wesley Professional, the author, or to buy the book.

This was last published in July 2005

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close