Chapter 18. Microsoft SQL Server 2005 Memory Configuration

Internal memory management for Microsoft SQL Server 2005 has changed in many ways since SQL Server 2000. Configuring memory on the system has remained very similar, though. This chapter covers the configuration topics. Configuring memory effectively can greatly improve database performance, so it is important to understand the options database admistrators have in this area. This chapter focuses on the basics of buffer cache management and memory configuration settings and options in SQL Server 2005 to allow you to make informed decisions about SQL Server memory configuration for performance. This chapter explains several important SQL Server ...

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.